Q.The difference (–) operation removes common tuples from the first relation. This operation is
Correct answer: non-commutative and associative
Explanation
The difference (–) operation in relational algebra removes tuples from the first relation that are also present in the second relation. This operation is - Non-commutative - A – B ≠ B – A, because the result depends on the order of the relations. Associative - (A – B) – C = A – (B∪C), as the grouping does not affect the result.
The difference (–) operation in relational algebra removes tuples from the first relation that are also present in the second relation. This operation is - Non-commutative - A – B ≠ B – A, because the result depends on the order of the relations. Associative - (A – B) – C = A – (B∪C), as the grouping does not affect the result.