Projection (Π) Operator

⇒ Projection Operator (Π) is a unary operator in relational algebra that performs a projection operation.

⇒ It projects (or displays) the particular columns {or attributes} from a relation and It delete column(s) that are not in the projection list.

⇒ It is denoted by Π.

⇒ Duplicate rows are automatically eliminated from result.

⇒ Notation:

Π A1,A2,A3...An (r)

Or

Π Attribute list (relation name/ table name)