Question: (a) Draw an Entity Relationship diagram (ERD) that represents the following business rules used in a Supermarket. No attribute is needed to indicate. (11%)

(a) Draw an Entity Relationship diagram (ERD) that represents the following business rules used in a Supermarket. No attribute is needed to indicate. (11%) A Customer must place at least one Order and an individual Order is assigned to one and one only Customer. A Salesperson may be assigned to many Customers and a Customer is assigned to one and only one Salesperson. An Order must contain at least one Product and a Product may appear on many Orders. Each individual Product is obtained from one Supplier and a Supplier has supplied at least one Product. Note: You must present your ERD with the current notation. (The old version, Dr Chen's notation, cannot be used) (b) Interpret the following ERD in English. (4%) Employee Employee NO F_Name Surname Room NO Phone Salary Start Date Works in Department NO Department Name Activate Windo Go to Settings to ac
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
