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?

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
This question is based on the four relations shown below.

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

This question is based on the four relations shown below.

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

1 Expert Approved Answer
Step: 1 Unlock

a Dish Washer 600 Refrigerator 1850 Lawn Mower 300 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

887-CS-DB (2227).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!