← 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?
- A.It is not even in 3NF
- B.It is in BCNF but not in 4NF
- C.It is in 4NF but not in BCNF
- 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 →