Question: 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
-1.png)
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
-2.png)
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?
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
Step by Step Solution
3.33 Rating (159 Votes )
There are 3 Steps involved in it
a Dish Washer 600 Refrigerator 1850 Lawn Mower 300 ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
887-CS-DB (2227).docx
120 KBs Word File
