Purchase Solution

SQL Conversion to Relational Algebra: Example Problem

Not what you're looking for?

Ask Custom Question

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;

Purchase this Solution

Solution Summary

Provides steps to convert the SQL to relational algebra.

Purchase this Solution


Free BrainMass Quizzes
Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Javscript Basics

Quiz on basics of javascript programming language.