🎙 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 12 of 15

Why is department.headid created as nullable at first?

Why is department.head_id created as nullable at first?

  1. A.department and faculty reference each other, so one table must be filled before the other's rows exist
  2. B.Heads are optional for every department
  3. C.Foreign keys can never be NOT NULL
  4. D.SQLite does not support foreign keys
Answer & explanation

Correct answer: department and faculty reference each other, so one table must be filled before the other's rows exist

The head is filled in with an UPDATE after the faculty rows are inserted.

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 →