HOMEWORK 4

 Schemas:

 Product(#prod,pname,price)
 Depot(#dep,addr,volume)
 Stock(#prod,#dep,quantity)

 Instances:

Product

#prod & pname & price  
p1 & tape & 2.5  
p2 & tv & 250  
p3 & vcr & 80  

Depot

#dep & addr & volume  
d1 & New York & 9000  
d2 & Syracuse & 6000  
d4 & New York & 2000  

Stock

#prod & #dep & quantity  
p1 & d1 & 1000 
p2& d4& 1500 
p2& d1& -400 
p3& d2& 2000 

Write the SQL expressions for the creation of the tables Product,
Depot and Stock (you must have at least one CHECK and at least one
FOREIGN KEY).

Write the SQL expressions for the creation of the instances of the
tables Product, Depot and Stock.

Write the following queries in SQL.

 Name and price of the products.
 Name of the products of the d2 depot
 Numbers of the depots that have products out of stock.
 Numbers and addresses of the depots that have products out of stock.
 Addresses of depots that stock all the products.
 Numbers and addresses of depots that stock all the products.