Which normal form ensures that every non-prime attribute in a table is fully functionally dependent on the primary key?

Options

  • A. First Normal Form (1NF)
  • B. Second Normal Form (2NF)
  • C. Third Normal Form (3NF)
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Second Normal Form (2NF)

Detailed Explanation

Explanation: Second Normal Form (2NF) requires a relation to be in 1NF and every non-prime attribute to be fully functionally dependent on every candidate key. It eliminates partial functional dependency.
← Previous Next →

Attempt Quiz Now:

TRE 4.0 DBMS Quiz Practice Set 1

Feature Posts