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
Suppliersupplierid name, city
Store storeid sname, city
Productbarcode pname, price, itsshoes, itsabag, color,
supplierid
Hasstockstoreid barcode, quantity
Express in tuple relational calculus algebra the following queries:
A Find the products that have price above eg CAD
B Find the barcodes of all products that have price above eg CAD
C Find the barcodes of the products that are sold in the store with storeid equal to but not
in the store with storeid equal to
D Find the barcodes of all the products that are sold in all the stores in the city of 'Ottawa'.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
