QUESTION 1

1. The Entity Relationship Diagram below shows the logical design of a database for Customers, Orders and Sales Representatives.

   

   1a. How many Entities are there?

   1b. A Customer can have a maximum of how many Sales Reps?

   1c. A Customer can have a minimum of how many Orders?

   1d. Which table does not need a Foreign Key?

   1e. Name one table that needs a Foreign Key?

   1f. A Sales Rep can have a maximum of how many Customers?

Customer Sales Rep PK Customer_ID PK Rep_ID H. Customer name Rep name Address Phone number Orders PK Order_ID Product