← 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?
- A.department and faculty reference each other, so one table must be filled before the other's rows exist
- B.Heads are optional for every department
- C.Foreign keys can never be NOT NULL
- 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 →