Explore BrainMass
Share

SQL Conversion to Relational Algebra: Example Problem

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 March 21, 2019, 6:05 pm ad1c9bdddf
https://brainmass.com/computer-science/sql/sql-conversion-relational-algebra-example-problem-244469

Solution Summary

Provides steps to convert the SQL to relational algebra.

$2.19