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?

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)
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).
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
Goal Seek is part of a suite of data tools used for ________
Fill in the blank(s) with correct word
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