Answered step by step
Verified Expert Solution
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
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
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