Map the high-level data model shown below to a set of relational tables. Identify primary, alternate, and foreign keys.

What will be an ideal response?


![15250|503x441](upload://ynWq8zjry7VGJrbGLYngvjccjYK.png)

Employee (SSN, fName, MI, lName, address, birthDate, sex, salary, number)
Primary Key SSN
Foreign Key number references Department (number)

Department (number, name, mgrSSN, startDate)
Primary Key number
Alternate Key name
Foreign Key mgrSSN references Employee (SSN)

DepartmentLocations (number, location)
Primary Key number, location
Foreign Key number references Department (number)

WorksOn (SSN, number, hours)
Primary Key SSN, number
Foreign Key SSN references Employee (SSN)
Foreign Key number references Project (number)

Project (number, name, location, dNumber)
Primary Key number
Foreign Key dNumber references Department (number)

SupervisoryTeam (supSSN, SSN)
Primary Key SSN
Foreign Key supSSN references Employee (SSN)
Foreign Key SSN references Employee (SSN)

(Or do not create SupervisoryTeam relation and simply add supSSN to Employee relation)

Dependent (SSN, name, sex, birthDate relationship)
Primary Key name, SSN
Foreign Key SSN references Employee (SSN)

Computer Science & Information Technology

You might also like to view...

____________________ is the amount of time by which an activity may be delayed from its scheduled Start date without the delay setting back the entire project.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

A PowerPoint presentation is made up of one or more ________ that can display text and graphics and other content

Fill in the blank(s) with correct word

Computer Science & Information Technology

Goal Seek is part of a suite of data tools used for ________

Fill in the blank(s) with correct word

Computer Science & Information Technology

When the mouse pointer points to an icon, which of the following displays and provides information about the icon?

A) Notification area B) Taskbar C) ScreenTip D) Shortcut menu

Computer Science & Information Technology