Use the following table to answer questions 1 through 6.
|
Order ID
|
Order Date
|
Customer ID
|
Customer Name
|
Product ID
|
Product Desc.
|
Product Price
|
Quantity Ordered
|
|
1006
|
10/24/10
|
2
|
Value Furniture
|
7
5
4
|
Dining Table
Writers Desk
Entertain Center
|
800.00
325.00
650.00
|
2
2
1
|
|
1007
|
10/25/10
|
6
|
Furniture Gallery
|
11
4
|
4 Drawer Dresser
Entertain Center
|
500.00
650.00
|
4
3
|
1. What errors prevent the table displayed above from being first normal form compliant?
2. Bring the table(s) into first normal form compliance without loss of any data. Identify primary and foreign keys (when present) for all tables.
3. What error(s), if any, prevent the now first normal form compliant table or tables from being second normal form compliant?
4. Bring the table(s) into second normal form compliance without loss of any data. Identify primary and foreign keys. Be sure to present all tables, not just those changed in this step of the normalization process.
5. What error(s), if any, prevent the now second normal form compliant table or tables from being third normal form compliant?
6. Bring the table(s) into third normal form compliance without loss of any data. Identify primary and foreign keys. Be sure to present all tables, not just those changed in this step of the normalization process.