10
4. Projection
•
Eliminates columns, then removes duplicates
•
Notation:
P
A1,…,An
(R)
•
Example: project social-security number and
names:
–
P
SSN, Name
(Employee)
–
Output schema:
Answer(SSN, Name)
–
•