🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.faculty.head_of_dept, allowing NULLs
  2. B.A new M:N table
  3. C.Nowhere — 1:1 relationships are not stored
  4. 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 →