Explore BrainMass

Explore BrainMass

    SQL Conversion to Relational Algebra: Example Problem

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 4, 2021, 9:26 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.49

    ADVERTISEMENT