Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Convert the following ERD. You should complete the conversion by hand and then select the appropriate conversion lines that makeup the full conversion. Notation Primary

Convert the following ERD. You should complete the conversion by hand and then select the appropriate conversion lines that makeup the full conversion.

image text in transcribed

Notation

Primary keys are denoted with a trailing asterisk. For example, if PersonID is a primary key, it will show as PersonID* in the answer choice(s).

Foreign keys are denoted with a trailing arrow. For example, if PersonID is a foreign key, it will show as PersonID-> in the answer choice(s).

All answers are either "YES" or "NO"

image text in transcribed

datechecklncheckOut 1:1 name(f,l)empld phone email employee (emplD*, nameFirst, nameLast, email, managerID->) employee_phone (emplD->, phone) shift (shiftID*, day, type) hours (date, checkln, checkOut, empID->, shiftID->, locationID->) location (locationID*, address, phone) employee (empID, nameFirst, nameLast, email, managerID) employee_phone (empID, phone) employee_email (empID->, email) shift (shiftID->, day, type) hours (date, checkln, checkOut, empID->, shiftID->) location (locationID, addressStr, addressCity, addressState, addressZip, phone) datechecklncheckOut 1:1 name(f,l)empld phone email employee (emplD*, nameFirst, nameLast, email, managerID->) employee_phone (emplD->, phone) shift (shiftID*, day, type) hours (date, checkln, checkOut, empID->, shiftID->, locationID->) location (locationID*, address, phone) employee (empID, nameFirst, nameLast, email, managerID) employee_phone (empID, phone) employee_email (empID->, email) shift (shiftID->, day, type) hours (date, checkln, checkOut, empID->, shiftID->) location (locationID, addressStr, addressCity, addressState, addressZip, phone)

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

Data Management Databases And Organizations

Authors: Richard T. Watson

2nd Edition

0471180742, 978-0471180746

More Books

Students also viewed these Databases questions

Question

What types of security and ethical dilemmas are facing pinterest.

Answered: 1 week ago

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago

Question

How would you assess the value of an approach like this?

Answered: 1 week ago

Question

When would you use one approach, and when would you use another?

Answered: 1 week ago

Question

3. How would this philosophy fit in your organization?

Answered: 1 week ago