WGU c170 PROJECT WITH COMPLETE SOLUTION

WGU c170 PROJECT WITH COMPLETE SOLUTION 1NF 2NF Highlighted fields will form a Composite primary key. City State and Zip were separated And are now atomic No duplicate data, each of the above tables has a Primary Key, and a key DONUT ORDER ID DONUT ID DATE CUSTOMER ID LAST NAME FIRST NAME STREET ADDRESS CITY STATE ZIP CODE HOME PHONE MOBILE PHONE OTHER PHONE DESCRIPTION QTY UNIT PRICE NOTES DONUT NAME DONUT ORDER ID(PK) DATE CUSTOMER ID LAST NAME FIRST NAME STREET ADDRESS APT CITY STATE ZIP CODE HOME PHONE MOBILE PHONE OTHER PHONE NOTES DONUT ID (PK) DONUT NAME DONUT DESCRIPTION UNIT PRICE DONUT ORDER ID (PK) (FK) QUANTITY DONUT ID (PK)(FK) (foreign) that can refer to another table in the group. 3NF No transitive dependency. New table has 2 of the PKs from the other tables as Foreign Keys. Each table has a primary key which can refer to another one of the tables in this group. CUSTOMER ID (PK) LAST NAME FIRST NAME STREET ADDRESS APT CITY STATE ZIP CODE HOME PHONE MOBILE PHONE OTHER PHONE DATE CUSTOMER ID (FK) NOTES DONUT ORDER ID (PK) DONUT ORDER ID (PK)(FK) QUANTITY DONUT ID (PK)(FK) DONUT ID (PK) DONUT NAME DONUT DESCRIPTION UNIT PRICE 1:M One Customer can place many Orders ORDER TABLE DATE DATETIME CUSTOMERID INT (fk) DONUT_ORDER_ID INT (pk) NOTES VARCHAR (255) ER DIAGRAM Customer table has single pk DONUT TABLE DONUT_ID INT (pk) DONUT_NAME VARCHAR (100) DONUT_DESCRIPTION VARCHAR (255) UNIT_PRICE DECIMAL (10,2) QUANTITY TABLE QUANTITY INT DONUT_ORDER_ID INT (pk) (fk) DONUT_ID INT (pk)(fk)