Basic of "RELATIONAL ALGEBRA" Operations

Projection

Selection

Union and Set-Difference

Union

Set Difference

Cross-Product

Compound Operator: Intersection

Intersection

Compound Operator: Join

Natural Join Example

Outer Joins

Compound Operator: Division

Aggregate Functions

Aggregate Operations

Aggregate Operation – Example

Assignment Operation