Question: Consider the relational database schema of Exercise 3 . Supplier ( supplier - id , name, city ) Store ( store - id , sname,

Consider the relational database schema of Exercise 3.
Supplier(supplier-id, name, city)
Store (store-id, sname, city)
Product(barcode, pname, price, itsshoes, itsabag, color,
supplier-id)
Has_stock(store-id, barcode, quantity)
Express in tuple relational calculus algebra the following queries:
A.(3%) Find the products that have price above 40(e.g. CAD).
B.(5%) Find the barcode(s) of all products that have price above 40(e.g. CAD).
C.(7%) Find the barcode(s) of the products that are sold in the store with store-id equal to '1' but not
in the store with store-id equal to '2'.
D.(10%) Find the barcode(s) of all the products that are sold in all the stores in the city of 'Ottawa'.
 Consider the relational database schema of Exercise 3. Supplier(supplier-id, name, city)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!