Consider the COMPANY relational database that you designed from Exercise $5($or use Exercise $5$ solution and create one$).$

Specify the following queries in SQL on the COMPANY database. Show the result of each query.

a$.$ Retrieve the names of all employees in department $5$ who work more than $10$ hours per week on the 'ProductX' project.

b$.$ List the names of all employees who have a dependent with the same first name as themselves.

c$.$ Find the names of all employees who are directly supervised by 'Franklin Wong'.

Specify the following updates using the SQL update commands. Show the state of each relation after the update.

a$.$ Insert $$'Robert',$\text{'}$F$\text{'},$'Scott',$\text{'}943775543\text{'},\text{'}1972-06-21\text{'},\text{'}2365$ Main St$,$ Bellaire, TX$\text{'},$M$,58000,\text{'}888665555\text{'},1>$ into EMPLOYEE.

b$.$ Insert 'John',$\text{'}$M$\text{'},\text{'}1990-12-12\text{'},$'spouse'$>$ into DEPENDENT.

c$.$ Delete the WORKS$\_$ON tuples with Essn $=\text{'}333445555\text{'}.$

d$.$ Modify the Mgr$\_$ssn and Mgr$\_$start$\_$date of the DEPARTMENT tuple with Dnumber $=5$ to $\text{'}123456789\text{'}$ and $\text{'}2007-10-01\text{'},$ respectively.

e$.$ Modify the Hours attribute of the WORKS$\_$ON tuple with Essn $={?}^{\text{'}}999887777$ 'and Pno $=10$ to $\text{'}5\mathrm{.}0\text{'}.$