Section 1 Donut ID (PK) Donut Order ID (PK) Customer ID Order Date First Name Last Name Street Address Apt # City Stat e Zip Code Home Phone Mobile Phone Other Phone IT C170 - Performance Assessment
1111111111111111111111111111111
First Normal Form I gathered all the data from the sales invoice and created an unnormalized dataset. I determined the primary key that provided me with a unique value for all my records in this table. I used composite primary keys because both keys would be able to uniquely identify all the data in the table. Finally, I removed all the repeating groups and made the address atomic by creating separate fields for each one. 1 / 2
Second Normal Form There is a multivalued key, so I looked for partial dependencies on part of this key. I had a partial dependency on Donut Order ID. I appropriated everything that was dependent on the Donut Order ID and generated a second table with them. I did the same for Donut ID and separated the rest into the Quantity table to provide a link between the two.Donut Order Quantity Donut Donut Order (PK) Customer ID Last Name First Name Street Address Apt # City Stat e Zip Code Home Phone Mobile Phone Other Phone Notes Order Date Donut Order
(PK)(FK)
Donut ID (PK)(FK) Quantity Donut ID (PK) Name Description Unit Price
- / 2