$1.[20$ points$]$ Given the following schema:

Manufacturer $\{$Name$,$ Street, City, State, Zip, Phone$\}$

Product $\{$PID$,$ Name, Buying$\_$Price, Selling$\_$Price, Size, Manufacturer$\_$Name$\}$ Foreign Key $\{$Manufacturer$\_$Name$\}$ references Manufacturer,

Warehouse $\{$Name$,$ Location, City, State, Zip, Space$\}$

Stores $\{$Warehouse$\_$Name, PID, Qty$\}$

Foreign Key $\{$Warehouse$\_$Name$\}$ references Warehouse, Foreign Key $\{$PID$\}$ references Product;

$$

Write SQL Queries for the following:

$$

$2.$ Create table Stores and make sure that when a Warehouse is deleted all related tuples in Stores also deleted.