normalization and refer to the database management system you are using for the appropriate SQL syntax.
Question:
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.
Solving Problems In Technical Communication
ISBN: 9780226924076
1st Edition
Authors: Johndan Johnson-Eilola, Stuart A. Selber