GeeksforGeeks App
Open App
Browser
Continue

# Difference between Relational Algebra and Relational Calculus

Both Relational Algebra and Relational Calculus are formal query languages.

### Relational Algebra:

Relational Algebra is a procedural language. In Relational Algebra, The order is specified in which the operations have to be performed. In Relational Algebra, frameworks are created to implement the queries. The basic operation included in relational algebra are:

```1. Select (σ)
2. Project (Π)
3. Union (U)
4. Set Difference (-)
5. Cartesian product (X)
6. Rename (ρ) ```

### Relational Calculus:

Relational Calculus is the formal query language. It is also known as Declarative language. In Relational Calculus, the order is not specified in which the operation has to be performed. Relational Calculus means what result we have to obtain.
Relational Calculus has two variations:

Relational Calculus is denoted as:

```{ t | P(t) }

Where,
t: the set of tuples
p: is the condition which is true for the given set of tuples.```

### Difference between Relational Algebra and Relational Calculus:

My Personal Notes arrow_drop_up