Skills101
← All practice quizzes

Quiz: 4NF and 5NF

5 questions · new set on every retakeNo time limitPass: 60%+10 XP on first pass

Some tables are in BCNF and still repeat data. Multivalued dependencies explain why and Fourth Normal Form fixes it; join dependencies lead to Fifth Normal Form. Both are shown with small SQL tables you can run.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

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

  2. Question 2

    In R(A, B, C), which multivalued dependency is trivial?

  3. Question 3

    Which statement is correct?

  4. Question 4

    Rows (Asha, DBMS, Hindi) and (Asha, OS, English) exist and teacher ↠ subject holds. Which row must also exist?

  5. Question 5

    How should R(teacher, subject, language) with teacher ↠ subject be decomposed into 4NF?

🎯 Today’s placement challenge — 10 questions, no login. Can you score 10/10?Take today’s challenge →