Answered step by step
Verified Expert Solution
Link Copied!

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

Entity-Relationship 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 number(s)). 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB 2008 Databases

Authors: Vidya Vrat Agarwal, James Huddleston

1st Edition

1590599470, 978-1590599471

More Books

Students also viewed these Databases questions

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago