1) Identify the Foreign Keys in each table: NOTE: Primary Keys for each table ar

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 D1

Explanation / Answer

1) Identify the Foreign Keys in each table:

NOTE: Primary Keys for each table are in BOLD LETTERS

Employee : DEPT# is Foreign Key

DEPARTMENT : DEPT# is Foreign Key

DIVISION : No Foreign Key

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.