Basic symbols of relational algebra

Posted on April 23, 2011April 23, 2011 by Adrian McMenamin

Apologies in advance but this blog might start to look like online revision notes (and a LaTeX scratchpad) for the next six weeks.

Projection

$\Pi_{field1, field2, \ldots fieldn} ( D )$

Selection

$\sigma_{field1=condition \wedge field2=condition}(D)$

Rename

$\rho ( E ( \bar F ) , D )$

Conditional Join

$D \Join _{field1 = condition} E$

Natural Join

$D \Join E$

(Page 100 onwards of Database Management Systems, Third Edition)

Advertisements

Published by Adrian McMenamin

Talk to the hand View all posts by Adrian McMenamin

%d bloggers like this: