Q1) Illustrate relational algebra expressions for
a. names of all salespeople
b. names of all salespeople having ORDER row
c. names of salespeople not having ORDER row
d. names of salespeople having order with Abernathy Construction
e. salaries of salespeople having order with Abernathy Construction
f. city of all CUSTOMERS having order with salesperson Jones
g. names of all sales people with the names of customers who have ordered from them. Include salespeople who have no orders.
Name Salary
Abel 120,000
Baker 42,000
Jones 36,000
Murphy 50,000
Zenith 118,000
Kobad 34,000
(SALESPEOPLE)
Number CustName SalespersonName Amount
100 Abernathy Construction Zenith 560
200 Abernathy Construction Jones 1800
300 Manchester Lumber Abel 480
400 Amalgamated Housing Abel 2500
500 Abernathy Construction Murphy 6000
600 Tri-city Builders Abel 700
700 Manchester Lumber Jones 150
(ORDER)
Name City IndustryType
Abernathy Construction Willow B
Manchester Lumber Manchester F
Tri-city Builders Memphis B
Amalgmated Housing Memphis B
(CUSTOMER)