In the context of relational database normalization, which of the following…
2026
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 30 students.
Show answer & explanation
Correct answer: A, B, C
In relational database normalization, 3NF decomposition always preserves dependencies using synthesis algorithms. All relations can be decomposed into 1NF while preserving dependencies. However, BCNF decomposition may lose dependencies in some cases. Option D is false because 2NF decompositions can preserve dependencies.