customer$($customerID$,$ firstName, lastName, city$)$

supplier$($supplierID$,$ name, street, city, phone, email$)$

product$($productID$,$ name, unit$\_$price, stock, supplierID$)$

customerorder$($customerID$,$ productID, odate, quantity$)$#Assume all tables have been created except for $$customerorder$.$ Create the

table $$customerorder$.$ The data type for customerID and productID is

VARCHAR$(5).$

Ensure you choose appropriate data types for the other columns, and you

specify the primary key and any foreign keys. $[6$ marks$]$

$($f$)$ Delete records in the customerorder that dates up to the end of December

$2009.[2$ marks$]$

$($g$)$ Create a view containing the productID, its name and stock. $[3$ marks$]$

$($h$)$ Give user $$john$$ permission to access $($read only$)$ the view created in part $($g$).$

You may assume that user $$john$$ has already been created.