Task: Translate the ER diagram to a Relational model then create the schema and populate the database using phpMyAdmin. Mapping the ER diagram to Relations: Customer (CustID (PK), Name, …) Product...

Task:

Translate the  ER diagram to a Relational model then create the schema and populate the database using phpMyAdmin.
Mapping the ER diagram to Relations:
Customer (CustID (PK), Name, …)
Product (ProdID (PK), Name, UnitPrice, …)
Order (OrdID (PK), OrdDate, CustID (FK))
OrderProduct (OrdID (PK,FK), ProdID (PK,FK), SalePrice, Qty