# Relational Data Manipulation (Relational Algebra) | Database Management System

# Relational Data Manipulation (Relational Algebra) | Database Management System

Relational Data Manipulation (Relational Algebra) | Database Management System

**The** **Relational Algebra**

- The
**relational algebra**is a procedural query language. Six fundamental operations:

- select (unary)
- project (unary)
- rename (unary)
- cartesian product (binary)
- union (binary)
- set-difference (binary)

- Several other operations, defined in terms of the fundamental operations:
- set-intersection
- natural join
- division
- assignment

- Operations produce a new relation as a result.

**Formal Definition of Relational Algebra**

- A basic expression Consists of either

- A relation in the database.
- A constant relation.

- General expressions are formed out of Smaller Subexpressions using