← Quiz: Normalization: all 10 questions
Quiz: Normalization · Question 9 of 10
In R(student, subject, teacher), (student, subject) → teacher and teacher → subject hold. Why is R not in BCNF?
In R(student, subject, teacher), (student, subject) → teacher and teacher → subject hold. Why is R not in BCNF?
- A.It has multi-valued cells
- B.
teacherdeterminessubjectbut is not a candidate key - C.It has no primary key
- D.It has a partial dependency on student
Answer & explanation
Correct answer: teacher determines subject but is not a candidate key
BCNF needs every determinant to be a candidate key.
Can you get the rest right without peeking?
Take the timed Quiz: Normalization quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →