GATE | CS | 2022 | Databases | Normalization & Normal Forms | Question 14

Last Updated :
Discuss
Comments

In a relational data model, which one of the following statements is TRUE?

A relation with only two attributes is always in BCNF.

If all attributes of a relation are prime attributes, then the relation is in BCNF.

Every relation has at least one non-prime attribute

BCNF decompositions preserve functional dependencies

Share your thoughts in the comments