a. Show the table in 1NF? (3 points)

b. Explain the Insert, Update and Delete anomalies in the above table. (3 points)

c. Identify the composite key and show the partial dependency and transitive dependency (5 points)

d. Show the tables in 2NF (4 points)

e. Show the tables in 3NF(5 points)

 

Normalization: Here is a table containing Product and Order details in an organization: OrderID Order Date 1006 1007 10/24/2010 Customer Customer Customer ProductID Product ID Name Address Description Plano, TX 2 Value Furniture 10/25/2010 6 Furniture Boulder, Gallery 7 5 4 11 Dining Table Writer's Desk Product Product Finish Standard Price 4-Dr Dresser Natural Ash Cherry 325.00 800.00 Entertainment Natural 650.00 Center Maple Oak 500.00 Entertainment Natural 650.00 Center Maple Ordered Quantity 2 2 1 4 3