In BCNF, what must be true about the determinant in every functional dependency?
2025
In BCNF, what must be true about the determinant in every functional dependency?
Answer: C. Determinant must be a candidate key — Correct answer: The determinant must be a candidate key. In Boyce-Codd Normal Form, for every non-trivial functional dependency X -> Y, X must be a superkey.…
- A.
Determinant can be any attribute
- B.
Determinant must be a primary key
- C.
Determinant must be a candidate key
- D.
Determinant must be a foreign key
- E.
Determinant can be a composite key or atomic key
Attempted by 496 students.
Show answer & explanation
Correct answer: C
Correct answer: The determinant must be a candidate key.
In Boyce-Codd Normal Form, for every non-trivial functional dependency X -> Y, X must be a superkey. Among the given options, the best match is that the determinant must be a candidate key; it cannot be just any attribute.