Which pair of relational algebraic operations requires union compatibility?
Which pair of relational algebraic operations requires union compatibility?
Intersection and difference require union compatibility because these operations involve combining or comparing tuples from two relations based on their common attributes. For intersection, the result is a set of tuples that are in both relations, so the attributes and their data types must match. For difference, the result is a set of tuples in one relation but not the other, which also requires matching attributes and data types to correctly compare the tuples.
C. Intersection and difference Union compatibility means that the two relations involved in the union, intersection, or difference operations must have the same set of attributes (columns) with compatible data types. The operations of union and intersection create a new relation that includes all the tuples that are present in both input relations, while the difference operation creates a new relation with tuples that are present in the first input relation but not in the second. These operations require the input relations to have the same set of attributes and data types to combine or compare the tuples correctly.