Data Set for Practicing Normalization

The following data set can be Normalized into a group of Relations (Tables, each with a Primary Key and Attributes) in Third Normal Form (3NF).

The correctly normalized relations can be found in the file named: “Normalization – Solution”

Data set:

Customer_Name, Customer_Address, Product_Description, Order_Number, Product_Number, Shipping_Quantity, Invoice_Number, Customer_Number, Product_Unit_Price, Order_Date, Order_Quantity, Customer_Phone, Product_Unit_Weight, Product_Unit_Cost, Invoice_Date, Extended_Item_Price, Total_Invoice_Price, Shipping_Date

REMEMBER!!!!!!

Spend some time working on this data set BEFORE you look at the solution! Once you look at the solution, your opinion will be tainted and you will not be able to work on this data set without having already colored your opinion of what the solution should be.