Relational Algebra in DBMS

Front

Relation

Back

A table in a database that consists of rows and columns.

Front

Tuple

Back

A single row in a relation, representing a single record.

Front

Attribute

Back

A column in a relation, representing a property of the data.

Front

Selection

Back

The operation of choosing a subset of rows from a relation based on a specified condition.

Front

Projection

Back

The operation of choosing a subset of columns from a relation.

Front

Union

Back

The operation that combines the results of two relations, including all unique rows.

Front

Intersection

Back

The operation that returns only the rows that are common to two relations.

Front

Difference

Back

The operation that returns the rows in one relation that are not in another.

Front

Cartesian Product

Back

The operation that returns all possible pairs of rows from two relations.