If a relation is in 2NF then
2008
If a relation is in 2NF then
- A.
every candidate key is a primary key
- B.
every non-prime attribute is fully functionally dependent on each relation key
- C.
every attribute is functionally independent
- D.
every relational key is a primary key
Attempted by 43 students.
Show answer & explanation
Correct answer: B
A relation is in Second Normal Form (2NF) if it satisfies First Normal Form and every non-prime attribute is fully functionally dependent on the candidate key. This eliminates partial dependencies where a non-prime attribute depends on only part of a composite primary key.
A video solution is available for this question — log in and enroll to watch it.
Loading lesson…