Vidyalelo
Database · Q37

The Relational Model and Normalization

Programming · Database · question 37

Q37

A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
Option1: True
In the Boyce-Codd Normal Form (BCNF), every determinant must be a candidate key, which means it can uniquely identify each tuple in the relation. If a determinant is a composite key, it means it is made up of multiple attributes that together uniquely identify a tuple. Therefore, if every determinant in a relation is a composite key, then the relation is in BCNF.

Option2: False
If every determinant in a relation is a composite key, then the relation is in BCNF. Therefore, the statement that a relation is in BCNF if every determinant is a composite key is true.

Conclusion: The correct option is True.