This question is based on the four relations shown below. Show the results along with the relational
Question:
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?
Step by Step Answer:
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel