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$)$:

Instructions:

$*$ YOU WILL NOT WRITE SQL CODE THIS WAY:

CREATE TABLE Product$($

prod$\_$id CHAR$(10),$

pname VARCHAR$(30),$

price DECIMAL,

PRIMARY KEY $($prod$\_$id$),$

CHECK $($price $>0))$;

$*$ BUT YOU WILL PROVIDE NAMES FOR ALL OF THE CONSTRAINTS AND USE ALTER TABLE:

$$CREATE TABLE Product$($

prod$\_$id CHAR$(10),$

pname VARCHAR$(30),$

price DECIMAL$)$;

ALTER TABLE Product ADD CONSTRAINT pk$\_$product PRIMARY KEY $($prod$\_$id$)$;

ALTER TABLE Product ADD CONSTRAINT ck$\_$product$\_$price CHECK $($price $>0)$;

Primary key constraints begin with pk$\_.$

Foreign key constraints begin with fk$\_.$

Check constraints begin with ck$\_.$

Follow instructions for above question and give what exactly question want.