A relation in which, if and only if every non-trivial, left-irreducible FD has…
2025
A relation in which, if and only if every non-trivial, left-irreducible FD has a candidate key as its determinant is known as
- A.
3NF
- B.
BCNF
- C.
Trivial FD
- D.
2NF
Attempted by 170 students.
Show answer & explanation
Correct answer: B
This question defines Boyce-Codd Normal Form (BCNF). In BCNF, every non-trivial functional dependency must have a candidate key as its determinant. This is stricter than Third Normal Form (3NF).