🎙 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 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?

  1. A.(teacher, subject) and (subject, language)
  2. B.(teacher, subject) and (teacher, language)
  3. C.(subject, language) and (teacher, language)
  4. 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 →