Questions and Answers
What is the primary requirement for a table to be in 1NF?
Each row must have a unique combination of values.
What is the condition for a table to be in 2NF?
It is in 1NF and has no partial dependencies.
What is the term for an attribute whose value determines other values within a row?
Determinant
Why is a determinant used as a primary key in a new table?
Signup and view all the answers
What is the characteristic of a candidate key?
Signup and view all the answers
What is the purpose of reassigning corresponding dependent attributes?
Signup and view all the answers
What is the condition for a table to be in 3NF?
Signup and view all the answers
What is the purpose of converting a table to 3NF?
Signup and view all the answers
What is the characteristic of the Boyce-Codd Normal Form?
Signup and view all the answers
What is the primary reason for using higher-level normal forms?
Signup and view all the answers