Consider two relational schemas:
emp(ID, name, address, phone number, deptID)
department(ID, managerID, deptname, location)
What does the following relational expression perform?
\(π_{(name, managerID)} (σ_{emp.deptID=department.ID} (σ_{deptname="Marketing"}(emp × department)))\)
1
Retrieves name of all employees in the Marketing department along with their manager ID.
2
Retrieves name of all employees in the Marketing department along with the department name.
3
Retrieves name of all employees in the Marketing department.
4
Retrieves name of all employees in the Marketing department along with their employee ID
5
Question Not Attempted