← Quiz: 4NF and 5NF: all 10 questions
Quiz: 4NF and 5NF · Question 5 of 10
How should R(teacher, subject, language) with teacher ↠ subject be decomposed into 4NF?
How should R(teacher, subject, language) with teacher ↠ subject be decomposed into 4NF?
- A.(teacher, subject) and (subject, language)
- B.(teacher, subject) and (teacher, language)
- C.(subject, language) and (teacher, language)
- D.It cannot be decomposed without loss
Answer & explanation
Correct answer: (teacher, subject) and (teacher, language)
Split on the MVD into (X, Y) and (X, Z); the join on teacher is lossless.
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 →