Which normal form is based on the condition that every determinant must be a candidate key?

Options

  • A. First Normal Form (1NF)
  • B. Boyce-Codd Normal Form (BCNF)
  • C. Fourth Normal Form (4NF)
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. Boyce-Codd Normal Form (BCNF)

Detailed Explanation

Explanation: BCNF requires every non-trivial functional dependency X → Y to have X as a super key. It is stricter than 3NF.