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
Roll_no |
Name |
Address |
Phone |
Age |
1 |
Ram |
Delhi |
9956879895 |
18 |
2 |
Ramesh |
Goa |
7825961432 |
18 |
3 |
Suresh |
Mumbai |
8569321478 |
20 |
4 |
Ravi |
Delhi |
6589321478 |
18 |
EMPLOYEE: R2
Emp_no |
Name |
Address |
Phone |
Age |
1 |
Ram |
Delhi |
9956879895 |
18 |
5 |
Geetha |
Mumbai |
8569741235 |
20 |
6 |
Swetha |
Ranchi |
9856741236 |
23 |
4 |
Ravi |
Delhi |
6589321478 |
18 |
STUDENT ∩ EMPLOYEE = STUDENT + EMPLOYEE - (STUDENT U EMPLOYEE)
Result:
Roll_no |
Name |
Address |
Phone |
Age |
1 |
Ram |
Delhi |
9956879895 |
18 |
4 |
Ravi |
Delhi |
6589321478 |
18 |