1NF 2NF Highlighted fields will form a Composite primary key. City State and Zip were separated And are now atomic DONUT ORDER ID (PK) (FK) QUANTITY DONUT ID (PK)(FK) No duplicate data, each of the above tables has a Primary Key, and a key (foreign) that can refer to another table in the group. 3NF No of Keys. transitive dependency. New table has 2 the PKs from the other tables as Foreign ER DIAGRAM ORDER TABLE DATE DATETIME 1:M One Customer can place many Ord Customer table has single pk DONUT TABLE DONUT_ID INT (pk) DONUT_NAME VARCHAR (100) DONUT_DESCRIPTION VARCHAR (255) UNIT_PRICE DECIMAL (10,2) 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 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

 

No comments found.
Login to post a comment
This item has not received any review yet.
Login to review this item
No Questions / Answers added yet.
Price $15.00
Add To Cart

Buy Now
Category exam bundles
Comments 0
Rating
Sales 0

Buy Our Plan

We have

The latest updated Study Material Bundle with 100% Satisfaction guarantee

Visit Now
{{ userMessage }}
Processing