Explore BrainMass
Share

SQL Conversion to Relational Algebra: Example Problem

This content was STOLEN 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 October 25, 2018, 12:53 am 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
See Also This Related BrainMass Solution

Database Questions

I need help with the below database questions:

1. White et al. (2007) discuss a number of ways that database systems experts can help computer game designers. Discuss an example and support it with insights from your own experience playing computer games.

2. Based on the Community Systems Group (2007) article, pick one of these research initiatives and explain one aspect of the DBMS technology that it relies on. Answer the question from a technical perspective and end-user perspective.

View Full Posting Details