Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Spatio Temporal Database Management International Workshop Stdbm 99 Edinburgh Scotland September 10 11 1999 Proceedings Lncs 1678

Authors: Michael H. Bohlen ,Christian S. Jensen ,Michel O. Scholl

1999th Edition

3540664017, 978-3540664017

More Books

Students also viewed these Databases questions