Relational Algebra Operators

by E-Computer Concepts October 16, 2019 at 7:31 pm

The Eight Relational Algebra Operators are:

Select

To retrieve specific tuples/rows from a relation.

Project

To retrieve specific attributes/columns from a relation.

Product

To obtain all possible combination of tuples from two relations.

Union

To retrieve tuples appearing in either or both the relations participating in the UNION.

Intersection

To retrieve tuples appearing in both the relations participating in the INTERSECT.

Difference

To retrieve tuples appearing in the first relation participating in the DIFFERENCE but not the second.

Join

To retrieve combinations of tuples in two relations based on a common field in both the relations.

Add Comment