Question: Draw an ER diagram including entity types, relationship types, attributes (including key attributes), and cardinality constraints. Note: If necessary optimize the ERD using Associative Entity.

 Draw an ER diagram including entity types, relationship types, attributes (including

Draw an ER diagram including entity types, relationship types, attributes (including key attributes), and cardinality constraints. Note: If necessary optimize the ERD using Associative Entity. Entity Types Regular Entities A Store has a Store Address, Store Supervisor ID, Store Manager ID, Employee ID number of employees A Supervisor has a Supervisor ID, Store Supervising, Name, Phone, Email A Manager has a Manager ID, Store Number Managing Name, Phone, Email An Employee has an Employee ID, Store Location, Name, Phone, Email A Customer Service Representative has a Customer Service ID A Customer has a Customer Membership ID, Name, Phone, Email, Shipping Address Associative Entities An Order has Order ID, Customer Membership ID, Customer Name, Customer Shipping Address, Customer Payment A Complaint has a Complaint ID, Customer Membership ID, Complaint

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!