Skip to content
#1. What is the purpose of denormalization in database design?
#2. Which normal form allows a relation to be in 5NF and eliminates join dependencies?
#3. What does the term “superkey” refer to in the context of database normalization?
#4. Which normal form allows a relation to be in 1NF and removes repeating groups?
#5. What is a composite key in the context of database normalization?
#6. Which normal form eliminates partial and transitive dependencies on a composite primary key?
#7. What is the primary purpose of BCNF (Boyce-Codd Normal Form) in database normalization?
#8. What is an atomic attribute in the context of normalization?
#9. Which normal form allows a relation to be in 2NF and removes partial dependencies?
#10. What is the key difference between 4NF (Fourth Normal Form) and BCNF (Boyce-Codd Normal Form)?
#11. What is a functional dependency in the context of database normalization?
#12. Which normal form allows a relation to be in 3NF and removes transitive dependencies between non-prime attributes?
#13. What is a transitive dependency in the context of database normalization?
#14. Which normal form allows a relation to be in 4NF and removes multivalued dependencies?
#15. What is the primary objective of normalization in database design?
#16. Which normal form eliminates the possibility of a transitive dependency between non-key attributes?
#17. In which normal form are non-prime attributes fully functionally dependent on every candidate key of the relation?
#18. What does the term “candidate key” refer to in normalization?
#19. What is the process of decomposing a relation into smaller, more manageable relations called?
#20. Which normal form allows a relation to be in 2NF and removes partial dependencies on a composite primary key?
