Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Office. Dunder Mifflin Paper Company, Inc. hired us to build their database system. The company wants to keep the information of the employees (

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.netLinks to an external site.. Remember notation, relationships, roles, cardinality, and participation. Use the export tool on draw.io to export the diagram as PDF file. Do NOT screenshot.

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

Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708

Authors: Philippa Gardner ,Floris Geerts

2009th Edition

3642037925, 978-3642037924

More Books

Students also viewed these Databases questions

Question

2. Outline the functions of nonverbal communication

Answered: 1 week ago