Relational Algebra Operations

Set theory Unary relational operation

Binary relational operation

Symbolic Notation use symbolic notation to represent the operators.

SELECT ->σ (sigma)

PROJECT -> π(pi)

PRODUCT -> ×(times)

JOIN -> |×| (bow-tie)

UNION -> ∪ (cup)

INTERSECTION -> ∩(cap)

DIFFERENCE -> - (minus)

RENAME ->ρ (rho)

(AND) -> ^

(OR) -> v

Not ->

S2-S1

R ∪ S R ∩ S R – S S - R

EXERCISE 1

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

Exercise 2

R ∪ S

Exercise 2 - PRODUCT

Exercise 3

Exercise 3 - SOLUTION

Exercise 4

Graduates – managers

Managers - graduates

Graduates U managers

Graduates ∩ managers

Exercise 4 - Solution

Exercise 4 - Solution

Exercise 4 - Solution

Exercise 5

Exercise 5 solution

Exercise 6

Exercise 7

Exercise 7 - solution