Going from Relational Algebra to SQL Currently In Progress

Project

The Project operator is used covertly in SQL as part of a Select Statement. Its use is still the same, to select the columns that we would like the resulting relation to contain.

Relational Algebra: ∏dob, empno(EMPLOYEE ) SQL Syntax: SELECT dob, empno FROM EMPLOYEE

Cross Join

Select

Rename

Natural Join