Relational Algebra

Table of Contents

Relational Algebra

Design Problem

Design Problem (II)

Design Problem (III)

Relational Algebra

Relational Algebra (II)

Selection (?)

Example

Projection (?)

Example

Product (?)

Theta-Join (|?|) C

Example

Example (II)

Natural Join (|?| )

Example

Example (II)

Example (II)

Renaming (?)

Example

Combining Operations

Operators

Operator Precedence

But there is no universal agreement, so we always put parentheses around the argument of a unary operator, and it is a good idea to group all binary operators with parentheses enclosing their arguments.

Each Expression Needs a Schema

Each Expression Needs a Schema (II)

Example

Example (II)

Example

PPT Slide

Linear Notation for Expressions

Example

Example

Email: burt@umbc

Home Page: www.cs.umbc.edu/~burt