Skip to content
#1. What does the term “candidate key” refer to in normalization?
#2. What is the process of decomposing a relation into smaller, more manageable relations called?
#3. Which normal form allows a relation to be in 2NF and removes partial dependencies on a composite primary key?
#4. What is a partial dependency in the context of database normalization?
#5. Which normal form ensures that non-key attributes are fully functionally dependent on the primary key?
#6. What is a multivalued dependency in the context of database normalization?
#7. Which normal form allows a relation to be in 3NF and removes transitive dependencies?
#8. What does the term “transitive dependency” mean in the context of normalization?
#9. Which normal form allows a relation to be in 4NF and removes multivalued dependencies?
#10. What is the primary objective of normalization in database design?
#11. Which normal form eliminates the possibility of a transitive dependency between non-key attributes?
#12. In which normal form are non-prime attributes fully functionally dependent on every candidate key of the relation?
#13. What does the term “candidate key” refer to in normalization?
#14. What is the process of decomposing a relation into smaller, more manageable relations called?
#15. Which normal form allows a relation to be in 2NF and removes partial dependencies on a composite primary key?
#16. What is a partial dependency in the context of database normalization?
#17. Which normal form ensures that non-key attributes are fully functionally dependent on the primary key?
#18. What is a multivalued dependency in the context of database normalization?
#19. Which normal form allows a relation to be in 3NF and removes transitive dependencies?
#20. What does the term “transitive dependency” mean in the context of normalization?
