Which of the following is a valid requirement for a relation to be in Third Normal Form (3NF)?

Options

  • A. The relation must be in 1NF only
  • B. The relation must be in 2NF and have no transitive dependency of non-prime attributes on candidate keys
  • C. Every table must contain exactly one primary key column
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. The relation must be in 2NF and have no transitive dependency of non-prime attributes on candidate keys

Detailed Explanation

Explanation: A relation in 3NF must be in 2NF and must not contain transitive dependencies of non-prime attributes on candidate keys. Formally, for every non-trivial FD X → A, X must be a super key or A must be a prime attribute.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 1

Feature Posts