The instructor relation has four fields: ID, name, dept_name and salary. If we want to list all instructor’s ID, name and salary, but not dept_name, which of the following operations would be used?
1
Union
2
Select
3
Set difference
4
Project
5
Question Not Attempted