Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Entity - Relationship Diagram ( ERD ) : USE CORRECT SHAPES AND ARROWS The Office. Dunder Mifflin Paper Company, Inc. hired us to build their
EntityRelationship Diagram ERD: USE CORRECT SHAPES AND ARROWS
The Office. Dunder Mifflin Paper Company, Inc. hired us to build their database system. The company wants to keep the information of the employees name email, hire date, seniority years, salary, phone numbers An employee may have multiple phone numbers, but a given phone number can only belong to a single employee. Employees work for a single branch, which is located in a given address, city, state. Branches are administrated by one manager, which must be one of the employees. No manager can administrate more than one branch. Moreover, an employee may be the supervisor for other employees, this way reflecting the hierarchy of the roles in the company employee assistant to the regional manager regional manager, etc, we only need to reflect who's the supervisor and who's the supervised, not the title The office is full of many different types of employees, but we only want to keep additional information for salesmen commission percentage they take in each sale and total annual sales each year and warehouse staff certifications certification name and date of certification Multiple employees can have the same certification earned on different dates.
Draw an ERD to represent the given problem using
diagrams.net. Remember notation, relationships, roles, cardinality, and participation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started