B.ERD

• Using your normalized tables (3NF), create the corresponding E-R Diagram in Drawio (Crow's

Foot)

• Specify the primary keys
• Specify the Connectivity and Cardinality
• For this assignment section, insert the exported JPEG image of your ERD in the word document.

Third Normal Form (3NF):

Customer Table - CustID (PK) - CustName - CustAddress - CustPhone

Delivery Table - DeliveryID (PK) - DeliveryDate - Weight - Fee - CustID (FK) - EmpID (FK)

Employee Table - EmpID (PK) - EmpName - EmpAddress - EmpPhone - EmpRating - PayRate