SQL Conversion to Relational Algebra: Example Problem

Convert this SQL statement into relational algebra:

SELECT COUNT(*)
FROM Employees e1,e2, Department d
WHERE e1.lName = 'Adams' AND e1.fName = 'James' AND
e1.empID = d.mgrEmpID AND d.deptNo = e2.deptNo;

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/computer-science/software-development/sql-conversion-to-relational-algebra-example-problem-7enl