A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.

Name: A relation is in 2NF if and only if it is in 1NF and all non-key attributes are determined by the entire primary key.
Brand: Quizplus
Rating: 4.7 (40 reviews)

Question

Quizplus · Accepted Answer

A relation is in Second Normal Form (2NF) if it is already in First Normal Form (1NF) and all non-prime (non-key) attributes are fully functionally dependent on the primary key, meaning they are determined by the entire primary key and not just a part of it.

A Relation Is in 2NF If and Only If It