This question is based on the four relations shown below. Show the results along with the relational algebra expressions for the following four retrieval requests?
a. Display the products and their associated prices for stores located in Houston?
b. Which products are not in the inventory of any sore?
b. Which products are offered at a 10% discount?
d. Which stores stock products with a price greater than $1000?
Store

Product
Products................. Price
Refrigerator............ 1850
Dish washer............ 600
Television................1400
Humidifier..............55
Vacuum Cleaner....... 300
Computer
Lawn Mower...........300
Washing Machine......750
Inventory
Disc_Structure

Quantity Discount
120.......................5%
150.......................5%
180.......................10%
280.......................10%
30
10
(a) Display the products and their associated prices for stores located in Houston?
(b) Which products are not in the inventory of any store?
(c) Which products are offered at a 10% discount?
(d) Which stories stock products with a price greater than $1000?

Transcribed Image Text:

t0re Location Sq-f Manager 15 13 14 Houston Tulsa Dalla Menphis Houston 2300 1900 300 1900 Metzger Metzger Schott Creech Parrish Store Quantity Refrigerator Dish Washer Dish Washer Refrigerator lelevisionn Humidifier Television Vacuum Cleaner Dish washer Computer Refrigerator Lawn Mower 120 150 180 150 280 30 10 150 150 120 180 13 14 14 17 17