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

  1. A.It has multi-valued cells
  2. B.teacher determines subject but is not a candidate key
  3. C.It has no primary key
  4. 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 →