What is the intersection operation in relational algebra-01373
This subjective question is related to the book/course vu eng301 Business Communication. It can also be found in vu eng301 Mid Term Solved Past Paper No. 1.
Question 1: What is the intersection operation in relational algebra?
Answer:
The intersection operation also has the requirement that both the relations should be union compatible, which means they are of same degree and same domains. It is represented by _. If R and S are two relations and we take intersection of these two relations then the resulting relation would be the set of tuples, which are in both R and S. Just like union intersection is also commutative. R _ S = S _ R (Page 154)