Task $6$

A$)$ Create all of the tables shown and insert all of the information displayed. Then, try

B$)$ Insert into Project relation:

$$ 'Terrible Project', NULL, 'Dublin', $4>$

C$)$ Insert into Works$\_$on relation: NULL$>$

D$)$ Insert into DEPT$\_$LOCATIONS relation: 'Houston'$>$

E$)$ Insert into Employee relation:

$$'Janet,$\text{'},\text{'},$'Smith', $\text{'}677678989\text{'},\text{'}1960-04-05\text{'},\text{'}6357$ Windswept, Katy, TX$\text{'},$ F$,28000,\text{'}987654321\text{'},9>$

F$)$ Delete any Dependent with Depentent$\_$name $=$ 'Elizabeth'

G$)$ Delete any tuples in Department with Mgr$\_$ssn$=\text{'}333445555\text{'}$

H$)$ Delete any tuples in Employee with Bdate $=\text{'}1965-01-09\text{'}$

Set the Mgr$\_$ssn in Department relation to NULL for any Department with Dno $=4$

J$)$ Update any Employee with SSN$=\text{'}333445555\text{'}$ to have date of birth $\text{'}1983-09-25\text{'}$

K$)$ Update the Pno to $21$ of all rows with ESSN$=123456789\text{'}$ in the Works$\_$on relation

For each part A$)-$K$)$ report whether or not the command executed $($YES$/$NO$)$ successfully and if it did not,

explain why not in your answer. give all SQL commands used to create the tables and perform the commands given in A$)-$K$)$