Answer-Given Employee(EmpID, Name, DeptID) and Department(DeptID, DeptName), which relational algebra expre...

First join the tables on the shared DeptID to correctly pair each employee with their department name, then select rows where DeptNameFinance, then project only the Name column. A plain Cartesian product without an explicit join condition would incorrectly pair every employee with every department.

Question

Given Employee(EmpID, Name, DeptI

D and Department(DeptID, DeptName), which relational algebra expression correctly retrieves the names of employees working in the 'Finance' department?

A π_Name(σ_DeptName='Finance'(Employee ⋈ Department))

B π_DeptName(σ_Name='Finance'(Employee ⋈ Department))

C σ_DeptName='Finance'(π_Name(Employee ⋈ Department))

D π_Name(σ_DeptName='Finance'(Employee × Department))

E σ_Name(π_DeptName='Finance'(Employee ⋈ Department))

Practice Next