The unary operations in Relational algebra are selection, projection, and rename. The select, project, and rename operators in relational algebra work on one relation only so they are called unary operators. In this article, we will discuss the unary operations in relational algebra. We will also discuss each unary operator in detail along with examples. Let’s start learning on the topic “Unary Operations in Relational Algebra”.

What is Relational Algebra?

Relational algebra is a procedural query processing language that provides the base of relational databases and SQL. Relational algebra has various operators like select, project, rename, cartesian product, union, intersection, set difference, joins, etc. These operators are used to form queries in relational algebra.

What are Unary Operations in Relational Algebra?

The operations that operate on only one relation are called unary operations in relational algebra. The three unary operations in relational algebra are:

• Selection
• Projection
• Rename

Selection Operation in Relational Algebra

The selection operation is a unary operation that is performed on one relation. The selection operation is used to retrieve tuples from the relation that satisfies the given condition. It is denoted by σ. Selection operation in relational algebra is written as:

σ_condition (Relationname)

We can also add multiple conditions if required using the operators ∧ (AND), ⋁and (OR). These operators are used to combine multiple conditions as required in the problem. Below is the selection operator representation with multiple conditions.

σ_{condition1 operator condition2 … condition n} (Relationname)

To select all the tuples of a relation we write the selection operation without any condition.

σ (Relationname)

Projection Operation in Relational Algebra

The projection operation is a unary operation that is performed on a relation. A projection operation is used to retrieve all the values of one or more attributes. It is denoted by π. Projection operation in relational algebra is written as:

π_columnname(Relationname)

We can add multiple column names in projection operation using the comma operator if required. The comma operator is used when we have to retrieve multiple column values. Below is the projection operation representation to output multiple columns.

π_{columnname1, columnname2, …,columnnamen} (Relationname)

Rename Operation in Relational Algebra

The rename operation is operation applied on one relation. Rename operation as the name suggests is used to rename the relation, attributes or both. It is denoted by ρ.

Rename Operation for Renaming Relation

Rename operation for renaming relation is written as:

ρ _{New_relation_name} (Old_relation_name)

For example: To rename relation R to S: ρ _S(R)

Rename Operation for Renaming Columns of Relation

Rename operation for renaming columns of relation is written as:

ρ _{(New_columnnames)} (Relation_name)

For example: To rename columns of relation R (a, b, c) to (x, y, z): ρ _{(x, y, z)} (R)

Rename Operation for Renaming Both Relation and Columns of Given Relation

Rename operation for renaming both relation and columns of relation R (a, b, c) is written as:

ρ _{New_relation_name(New_columnnames)} (Old_relation_name)

For example: To rename both relation and columns of R (a, b, c) to S (x, y, z): ρ _{S (x, y, z)} (R)

Example on Unary Operations in Relational Algebra

Example 1: Consider the below given table and write the queries in relational algebra for the questions given below.