Share
Explore BrainMass

Relational Algebra Expressions for the attached file !

Show relational algebra expressions for:

a. The names of all salespeople.
b. The names of all salespeople having an ORDER row.
c. The names of salespeople not having an ORDER row.
d. The names of salespeople having an order with Abernathy Construction.
e. The salaries of salespeople having an order with Abernathy Construction.
f. The city of all CUSTOMERS having an order with salesperson Jones.
g. The names of all salespeople with the names of customers who have ordered from them. Include salespeople who have no orders.

Please refer to the attached file for complete question.

Attachments

Solution Summary

The attached file contains the relational expressions for the tables given in the attached file. Grab it and enjoy the solution.

$2.19