Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are a database designer. You give your manager the following fragment of an ER diagram. Your manager asks you about boxes and funny lines

image text in transcribed

You are a database designer. You give your manager the following fragment of an ER diagram. Your manager asks you about boxes and funny lines between the two boxes. Explain what those boxes and lines are and what they mean. Remember to explain everything in the diagram, i.e., what are the entities and what type of relationship they are in, and assumptions (if any) that you are making. Manager to Employee Entity: An entity is an object that exists. An entity can be a single thing, person, place, or object. In the given requirement the following are the entities: Manager Employee Relationship 1 or No Manager can manage one or more Employees One or more employees can be managed by 0 or 1 manager. Using the diagram above as your starting point, draw an ER diagram (including primary keys and attributes) in which the manager supervises both full time and part time employees. For all employees you want to track their employee type ("Full-time" or "Part-time"), SSN, name, address, and phone number. For full time employees you want to track their salary, benefits and 401k matching %. For part time employees you want to track their hourly rate, hours worked per week, and benefits. An employee can only be a part or full time employee. Benefits of a full-time employee are different from the benefits of a part-time employee. List any assumptions you have made

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

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions