Answered step by step
Verified Expert Solution
Question
1 Approved Answer
AutoSave OF E AA5- 7- Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments Times New... v
AutoSave OF E AA5- 7- Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments Times New... v 12 A T Aabets Aaubete Nem AaBCCD AaB+CcDar AaBb A Q Pastc I U X Na Sancing Title Hestling Handling 1 A 2A Styles Pane Dictate Sensitivity Question 1: 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 10 *Employee Answer: Question 2: Using the diagram in Question 1 as your starting point, draw an ER diagram (including primary kcys and attributes) in which the manager superviscs both full time and part time employecs. For all employees you want to track their cmployce type ("Full-time" or "Part- time"), SSN, name, address, and phone number. For full time employecs 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 employec. Benefits of a full-time employee are different from the benefits of a part-time employee. List any assumptions you have made Answer: Page 1 of 1 107 of 285 words English (United States Focus 3 + 150%
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