Intermediate
Database Management Systems
Q42 / 100
What is the third normal form (3NF)?
Correct! Well done.
Incorrect.
The correct answer is A) All columns must depend on the primary key, not on each other (no transitive dependencies)
A
Correct Answer
All columns must depend on the primary key, not on each other (no transitive dependencies)
Explanation
3NF: all non-key columns must be directly dependent on the primary key (not on other non-key columns). Example: if ZIP→City, store ZIP and City in a separate table.
Progress
42/100