Relational Algebra Operators
The Eight Relational Algebra Operators are:
To retrieve specific tuples/rows from a relation.
To retrieve specific attributes/columns from a relation.
To obtain all possible combination of tuples from two relations.
To retrieve tuples appearing in either or both the relations participating in the UNION.
To retrieve tuples appearing in both the relations participating in the INTERSECT.
To retrieve tuples appearing in the first relation participating in the DIFFERENCE but not the second.
To retrieve combinations of tuples in two relations based on a common field in both the relations.