Relational Algebra Visualizer

SELECT (σ) - Filter Rows

Filters rows based on conditions. Use column names with operators:

• Age > 21 - Numbers greater than 21
• Name = "Arjun Sharma" - Exact text match
• City = "Mumbai" - Filter by city
• Salary > 50000 - Salary conditions
• Department != "HR" - Not equal to HR

PROJECT (π) - Select Columns

Selects specific columns and removes duplicates automatically.

Example: Select "Name, City, Department" to show only those columns.

JOIN (⋈) - Combine Tables

Combines rows from two tables based on matching values.

Format: Table1.Column1 = Table2.Column2

UNION (∪) - Combine All Rows

Combines all rows from two compatible tables, removing duplicates.

DIFFERENCE (−) - Subtract Tables

Returns rows in first table that are NOT in the second table.

INTERSECTION (∩) - Common Rows

Returns rows that exist in BOTH tables. Tables must have compatible schemas.

CARTESIAN PRODUCT (×) - Cross Product

Combines every row from first table with every row from second table. Results can be very large!

RENAME (ρ) - Change Names

Changes table name or column names without affecting the data.

Format: ρ(NewName)(OldTable) or ρ(NewCol1, NewCol2)(Table)

DISTINCT - Remove Duplicates

Removes duplicate rows, keeping only unique tuples in the result.

DIVISION (÷) - Advanced Query

Returns tuples from dividend that are associated with ALL tuples in divisor. Used for "for all" queries.

Keyboard Shortcuts

• Ctrl + Enter - Run Quick Demo
• Ctrl + H - Toggle Help Mode
• F1 - Show Help
• Escape - Close Modals