Consider the schemas and instances below.

#prod should be prodid

#dep should be depid.

The primary key of product is prodid. The primary key of depot is depid. The $($composite$)$ primary key of stock is prodid, depid.

prodid in stock is a foreign key referring the primary key prodid in product.

depid in stock is a foreign key referring the primary key depid in depot.

$*$ Schemas:

$-$Product$($#prod, pname, price$)$

$-$Depot $($#dep, addr, volume$)$

$-$Stock $($#prod, #dep, quantity$)$

$*$Instanoes:

Product

#prod pname price

p$1$ tape $2\mathrm{.}5$

p$2$ tv $250$

p$3$ ver $80$

Depot

#dep addr volume

d$1$ New York $9000$

d$2$ Syracuse $6000$

d$4$ New York $2000$

Stock

#prod #dep quantity

p$1$ d$11000$

p$1$ d$2-100$

p$1$ d$41200$

p$3$ d$13000$

p$3$ d$42000$

p$2$ d$41500$

p$2$ d$1-100$

p$2$ d$22000$

Write the code that will create the tables: product, depot and stock, and populate them with the provided data following the instructions below.

SQL code $($tested in PostgreSQL without syntax errors$)$: