Intermediate
Database Management Systems
Q68 / 100
What is the second normal form (2NF)?
Correct! Well done.
Incorrect.
The correct answer is A) A table is in 1NF and every non-key column is fully functionally dependent on the entire primary key, eliminating partial dependencies
A
Correct Answer
A table is in 1NF and every non-key column is fully functionally dependent on the entire primary key, eliminating partial dependencies
Explanation
2NF removes partial dependencies that occur with composite keys: a non-key column depending on only part of the composite key must be moved to its own table. This applies only when the primary key has multiple columns.
Progress
68/100