203k views
4 votes
A BCNF relation is always in 3rd normal form?
1) True
2) False

User Ealhad
by
8.3k points

1 Answer

5 votes

Final answer:

A BCNF relation is not always in 3rd normal form. BCNF is a more stringent form of normalization compared to 3NF.

Step-by-step explanation:

A BCNF relation is not always in 3rd normal form. In fact, 3rd normal form (3NF) is a lower level of normalization compared to Boyce-Codd normal form (BCNF). BCNF is a more stringent form of normalization that eliminates all partial dependencies. It ensures that every non-key attribute is functionally dependent on the whole primary key. On the other hand, 3NF allows dependent attributes to be partially dependent on the primary key.

User Abhistin
by
9.6k points