Suppose you have: Employee(EmpID, DeptNo, Salary)
Department(DeptNo, Manager)
Which Relational Algebra expression finds the managers of employees earning more than 50,000?

Question

Suppose you have: Employee(EmpID, DeptNo, Salary) 
 Department(DeptNo, Manager) 
 Which Relational Algebra expression finds the managers of employees earning more than 50,000?

Answer

σ Manager > 50000 (Employee ⨝ Department)

Answer

π Salary (Employee ⨝ Department)

Answer

π DeptNo (σ Manager > 50000 (Department))

Answer

π Manager (σ Salary > 50000 (Employee) ⨝ Department)

Crowdly

Suppose you have: Employee(EmpID, DeptNo, Salary) Department(DeptNo, Manager)...

Want instant access to all verified answers on moodle.spit.ac.in?