Set Operations
Binary operations
- Result is table(set) with same attributes
Sets must be compatible!
- R1(A1,A2,A3), R2(B1,B2,B3)
- Domain(Ai)=Domain(Bi)
Union: all tuples in R1 or R2
Intersection: all tuples in R1 and R2
Difference: all tuples in R1 and not in R2
No complement… what’s the universe?