Convert sql statement into relational algebra


Discuss the below:

Q: Convert 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;

 

Solution Preview :

Prepared by a verified Expert
Database Management System: Convert sql statement into relational algebra
Reference No:- TGS01939049

Now Priced at $25 (50% Discount)

Recommended (97%)

Rated (4.9/5)