In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have are
Answer: ∪,−
When we apply the intersection operation on two relations R1 and R2, we will get tuples which are in R1 as well as R2. In terms of basic operators intersection means union and minus.
Let's consider one example:
STUDENT: R1
EMPLOYEE: R2
STUDENT ∩ EMPLOYEE = STUDENT + EMPLOYEE - (STUDENT U EMPLOYEE)
Result:
64.3k questions
77.9k answers
244k comments
80.0k users