← Quiz: ER to Tables: all 15 questions
Quiz: ER to Tables · Question 6 of 15
"Each department has exactly one head; most faculty are not heads." Where should the foreign key go?
"Each department has exactly one head; most faculty are not heads." Where should the foreign key go?
- A.faculty.head_of_dept, allowing NULLs
- B.A new M:N table
- C.Nowhere — 1:1 relationships are not stored
- D.department.head_id, marked UNIQUE
Answer & explanation
Correct answer: department.head_id, marked UNIQUE
The department side has total participation, so the column is never NULL there, and UNIQUE keeps it 1:1.
Can you get the rest right without peeking?
Take the timed Quiz: ER to Tables quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →