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?
If the decomposition is not dependency-preserving, some functional dependency involves attributes that now sit in different relations. To check it after an update the relations have to be joined first, which is expensive. So the join operator is the one run more often.
More Integrity constraints and normal forms questions
GATE 2025 DA Q56– Consider the following two relations, named Customer and Person, in a database: Person…
GATE 2025 DA Q57– Consider a database relation R with attributes ABCDEFG, and having the following…
GATE 2024 DA Q46– Given the relational schema R = (U, V, W, X, Y, Z) and the set of functional dependencies:…
GATE 2026 DA Q17– Let R(A,B,C,D,E) be a relational schema with functional dependency set F = \A BC,\ CD E,\…
GATE 2026 DA Q26– Consider two relations r and s defined on the relational schemas R(A,B) and S(E,C),…