Explore BrainMass
Share

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;

© BrainMass Inc. brainmass.com August 17, 2018, 5:05 am ad1c9bdddf

Solution Summary

Provides steps to convert the SQL to relational algebra.

$2.19