In the context of relational database normalization, which of the following…

GATE · 2026 · CS · Set 1 · Computer Science & IT

In the context of relational database normalization, which of the following statements is/are true?

A.
It is always possible to obtain a dependency-preserving 3NF decomposition of a relation
B.
It is always possible to obtain a dependency-preserving 1NF decomposition of a relation
C.
It is not always possible to obtain a dependency-preserving BCNF decomposition of a relation
D.
It is not always possible to obtain a dependency-preserving 2NF decomposition of a relation

Attempted by 207 students.