normalization and refer to the database management system you are using for the appropriate SQL syntax.

 

Normalization to 1NF, 2NF, and 3NF

 

given set of unnormalized data and apply the principles of normalization to bring it to the First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF) as we discussed in class.

 

 Dataset: Consider the following unnormalized dataset representing information about customers and their orders: 

 

Customer_Order (Unnormalized) 

 

CustomerID | CustomerName | OrderID | OrderDate | Product | Quantity | TotalPrice 

101 | Alice | 1 | 2022-01-15 | Laptop | 2 | 2000 

101 | Alice | 2 | 2022-02-20 | Printer | 1 | 150 

102 | Bob | 3 | 2022-01-10 | Laptop | 1 | 1000 

103 | Carol | 4 | 2022-03-05 | Monitor | 2 | 400 

103 | Carol | 5 | 2022-03-15 | Printer | 1 | 150

104 | Dave | 6 | 2022-02-05 | Laptop | 2 | 2000 

 

Please answer the following questions: 

 

1. Transform the given dataset into First Normal Form (1NF). Your result should be a set of tables that eliminate any repeating groups and ensure atomicity. 

 

2. From the 1NF result, further normalize the data into Second Normal Form (2NF) by identifying the candidate keys and creating separate tables for related data. 

 

3. Finally, continue the normalization process by achieving Third Normal Form (3NF) by eliminating transitive dependencies. 

 

4. Document your work and provide a brief explanation for each step you take in the normalization process. 

 

5. After achieving 3NF, write the SQL CREATE TABLE statements for the normalized tables. 

 

Rubric 

 -P-repare solutions in a clear and organized format.

 - Include SQL statements for creating the tables after reaching 3NF.