Relational Algebra

Relational Algebra consists of several groups of operations
Unary Relational Operations
SELECT (symbol: s (sigma))
PROJECT (symbol: _ (pi))
RENAME (symbol: r (rho))
Relational Algebra Operations From Set Theory
UNION ( U ), INTERSECTION ( _ ), DIFFERENCE (or MINUS, – )
CARTESIAN PRODUCT ( x )
Binary Relational Operations
JOIN (several variations of JOIN exist)
DIVISION
Additional Relational Operations
OUTER JOINS, OUTER UNION
Unary Relational Operations
SELECT (symbol: s (sigma))
PROJECT (symbol: _ (pi))

RENAME (symbol: r (rho))

0 comments