If a relational decomposition is not dependency-preserving, which one of the following relational operators will be executed more frequently in order to maintain the dependencies?
A.
Selection
B.
Projection
C.
Join
D.
Set union
Solution:
(C) Join
Because if the decomposition is not dependency-preserving, we need to use JOINs frequently to reconstruct the original relation and enforce/check dependencies.