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.