Question

For this first part, you will be creating an EER Diagram using MySQL Workbench for a store with employees. Below are the requirements for this EER Diagram.

Rules:

• The store has employees (ID, last, first, hire date, release date, manager)
• All employees must work at a store
• An employee may have a manager
• An employee can be assigned to more than one store
• A store can have more than one employee
• All stores belong to a region
• A store can be in only one region
• Remember to add relationship labels to All relationships

Answer 1

Based on the given scenario, the entities are:

• Store
• Employee
• Manager
• Region

Key points:

• An employee may have a manager (Manager: Employee - 1:N)
• An employee can be assigned to more than one store. A store can have more than one employee. (Store: Employee - M: M)
• A store can be in only one region (Store: Region - 1:1)
• Each store contains one manager(Store: Manager - 1:1 )

ERD diagram: