A table where every determinant is a candidate key is said to be in ____.
A) BCNF
B) 2NF
C) 3NF
D) 4NF

Question

Quizplus · Accepted Answer

A table where every determinant is a candidate key is said to be in Boyce-Codd Normal Form (BCNF). This means that the table is free of redundant data, and every attribute is dependent on the candidate keys. BCNF is a higher normal form than 2NF and 3NF, meaning that if a table is in BCNF, it automatically meets the criteria for 2NF and 3NF. Therefore, the best choice is A.

A Table Where Every Determinant Is a Candidate Key Is