Relational Algebra Tutorial

Database | Home











 


assignment
  - the operation denoted by which is used to assign expressions to a temporary relation variable.

Cartesian product
  - the operation denoted by a cross (X) allows for combination of information from any two relations.

division   - the operation denoted by and used in queries wanting to find results including the phrase "for all".

natural join
  - the operation that pertains to a query that involves a Cartestian product includes a selection operation on the result of the Cartesian product.

project
  - the operation denoted by the Greek letter pi (), which is used to return an argument with certain attributes left out.

rename   - the operation denoted by the Greek letter rho (), which allows the results of a relational-algebra expression to be assigned a name, which can later be used to refer to them.
select - the operation denoted by the Greek letter sigma (), which enables a selection of tuples that satisfy a given predicate.

set difference
  - the operation denoted by - allows for finding tuples that are in one relation but are not in another.

set-intersection
  - the operation denoted by which results in the tuples that are in both relations the operation is applying to.
union
  - an operation on relations that yields the relation of all tuples shared by two or more relations. Denoted by the symbol:


Database | Home | Top of page