Relational Algebra special characters

Unary operators

selection: σcname<cname2 ∧ enr>10000

projection: ΠcnameE

Aggregate function:

Binary operators

union: E1 ∪ E2
intersection: E1 ∩ E2
difference: E1 − E2
Cartesian product: E1 × E2
division: E1 ÷ E2

rename: ρ isStudent or ρ S2(isStudent)

Natural join: ⋈
Theta join: ⋈condition

Left semijoin: ⋉
Right semijoin: ⋊
left outer join: ⟕
right outer join: ⟖
full outer join: ⟗
antijoin: ▷

Logic symbols

Logical AND: ∧
Logical OR: ∨
Logical NOT: ¬

Other

null: ω