In the context of Normalization, what is the primary requirement for a…
2026
In the context of Normalization, what is the primary requirement for a relation to be in Third Normal Form (3NF) ?
- A.
It must be in 2NF and have no partial functional dependencies
- B.
It must be in 2NF and have no transitive dependencies
- C.
All determinants must be candidate keys
- D.
Every non-key attribute must be fully functionally dependent on the primary key only
Attempted by 229 students.
Show answer & explanation
Correct answer: B
A relation is in Third Normal Form (3NF) if it satisfies Second Normal Form (2NF) and has no transitive dependencies.