1. Identify the Foreign Keys in each table: NOTE: Primary Keys for each table ar
ID: 3731634 • Letter: 1
Question
1. Identify the Foreign Keys in each table:
NOTE: Primary Keys for each table are in BOLD LETTERS
Employee
DEPARTMENT
DIVISION
NOTE: Primary Keys for each table are in BOLD LETTERS
EMP# SOCSEC FNAME LNAME SEX SPOUSE SALARY JOBCODE DIVNAME DEPT# E1 123-45-6789 JACK SPRATT M E2 12,500 CLERK FINANCE D3 E2 987-65-4321 JANE SPRATT F E1 55,000 SALES MARKETING D1 E3 NULL DIICK BUTKUS M NULL 44,000 SALES MARKETING D2 E4 458-22-1513 SAM SPADE M E5 12,800 NULL LEGAL D2 E5 321-47-1698 LAUREN BACALL F E4 19,500 PROG MARKETING D1Explanation / Answer
Following is tthe answer:
Employee Table:
EMP is Primary Key.
DIVNAME is Foreign Key reference to Department Table.
DEPT is Foreign Key reference to Department Table.
DEPARTMENT Table:
DIVNAME is Primary Key.
DEPT is Primary Key.
MANAGER is Foreign Key references to Employee(SPOUSE) Table.
DIVISION Table:
DIVNAME is Primary Key.
DIRECTOR is Foreign Key references to DEPARTMENT(MANAGER) Table.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.