CREATE DATABASE IF NOT EXISTS RetailDB;

USE RetailDB;

DROP TABLE IF EXISTS Contain;

DROP TABLE IF EXISTS OrdersPlaces;

DROP TABLE IF EXISTS Items;

DROP TABLE IF EXISTS Phones;

DROP TABLE IF EXISTS Customers;

CREATE TABLE Customers$($

custid CHAR$(9),$

fName VARCHAR$(20),$

lName VARCHAR$(20),$

password VARCHAR$(40),$

PRIMARY KEY$($custid$))$;

CREATE TABLE Phones$($

custid CHAR$(9),$

phone CHAR$(12),$

PRIMARY KEY$($custid$,$phone$),$

FOREIGN KEY$($custid$)$ REFERENCES Customers$($custid$))$;

CREATE TABLE Items$($

iID CHAR$(5),$

name VARCHAR$(40),$

price DECIMAL$(6,2),$ #its maximum value is $9,999\mathrm{.}99$

qtyInStock SMALLINT,

PRIMARY KEY $($iID$))$;

CREATE TABLE OrdersPlaces$($

oID CHAR$(8),$

ordDate DATE,

shippingDate DATE,

receivalDate DATE,

payAmount DECIMAL$(8,2),$ #its maximum value is $999,999\mathrm{.}99$

payMethod VARCHAR$(20),$

custid CHAR$(9)$ NOT NULL,

PRIMARY KEY $($oID$),$

FOREIGN KEY$($custid$)$ REFERENCES Customers$($custid$))$;

CREATE TABLE Contain$($

oID CHAR$(8),$

iID CHAR$(5),$

price DECIMAL$(6,2),$

qty SMALLINT,

PRIMARY KEY $($oID$,$iID$),$

FOREIGN KEY$($oID$)$ REFERENCES OrdersPlaces$($oID$),$

FOREIGN KEY$($iID$)$ REFERENCES Items$($iID$))$;

$****$answer tasks using these tables$*****$