MADE EASY Relational Algebra

Question

In a relational algebra ∩  is not a basic operator, to make it basic only relational operator we should have are

1. X, –
2.  X, U
3. U, –

Comments

$(A' \bigcup ( A - B) )'$

---

Five basic operations in relational algebra: Selection, Projection, Cartesian product, Union, and Set Difference.

---

A-(A-B)

Answer 1

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

Comments

Thank u.. :)