🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: 4NF and 5NF: all 10 questions

Quiz: 4NF and 5NF · Question 1 of 10

Table R(teacher, subject, language) has teacher ↠ subject and teacher ↠ language, and its only key is all three columns…

Table R(teacher, subject, language) has teacher ↠ subject and teacher ↠ language, and its only key is all three columns. Which is true?

  1. A.It is not even in 3NF
  2. B.It is in BCNF but not in 4NF
  3. C.It is in 4NF but not in BCNF
  4. D.It is in 5NF
Answer & explanation

Correct answer: It is in BCNF but not in 4NF

It has no non-trivial FDs, so BCNF holds; the MVD has a non-superkey on the left, so 4NF fails.

Can you get the rest right without peeking?

Take the timed Quiz: 4NF and 5NF quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →