In context of data normalization in database management system, relation is in…
2023
In context of data normalization in database management system, relation is in Boyce-Codd Normal Form if and only if every determinant is a _____ .
- A.
Foreign key
- B.
Non-primary key
- C.
Alternate key
- D.
Candidate key
Attempted by 170 students.
Show answer & explanation
Correct answer: D
A relation is in BCNF if every determinant is a candidate key. This is stricter than the usual 3NF condition.