Home » MCQs » DBMS MCQs » DBMS Relational Decomposition MCQs

___ a relation R into its dependency relations R1 and R2 requires that the dependencies of R either be a part of R1 or R2 or be derivable from the combination of the functional dependency relationships of R1 and R2

12. ___ a relation R into its dependency relations R1 and R2 requires that the dependencies of R either be a part of R1 or R2 or be derivable from the combination of the functional dependency relationships of R1 and R2.

1. Composing
2. Decomposing
3. Both A and B
4. None of the above

Answer: B) Decomposing

Explanation:

Decomposing a relation R into its dependency relations R1 and R2 requires that the dependencies of R either be a part of R1 or R2 or be derivable from the combination of the functional dependency relationships of R1 and R2.