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

GATE · 2022 · CS · Computer Science & IT

1. A.

   A relation with only two attributes is always in BCNF.

2. B.

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

3. C.

   Every relation has at least one non-prime attribute.

4. D.

   BCNF decompositions preserve functional dependencies.

Attempted by 1124 students.