← All topics
Quiz: 4NF and 5NF: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. Table R(teacher, subject, language) has teacher ↠ subject and teacher ↠ language, and its only key is all three columns. Which is true?
- Q2. In R(A, B, C), which multivalued dependency is trivial?
- Q3. Which statement is correct?
- Q4. Rows (Asha, DBMS, Hindi) and (Asha, OS, English) exist and teacher ↠ subject holds. Which row must also exist?
- Q5. How should R(teacher, subject, language) with teacher ↠ subject be decomposed into 4NF?
- Q6. What does this print? (code)
- Q7. What is a join dependency?
- Q8. What is another name for 5NF?
- Q9. In the agent–company–product example, why is joining only agentcompany and companyproduct not enough?
- Q10. Which ordering of normal forms from least strict to most strict is correct?