$6.$ Specify the following queries on the COMPANY relational database schema shown in Figure $5\mathrm{.}5($page $161,7$th edition$),$ using the relational operators. Also show the result of each query as it would apply to the database state of Figure $5\mathrm{.}6($page $162,7$th edition$).$ Figure $5\mathrm{.}6$

One possible database state for the COMPANY relational database schema.

EMPLOYEE

DEPARTMENT

DEPT$\_$LOCATIONS

PROJECT

DEPENDENT EMPLOYEE

DEPARTMENT

DEPT$\_$LOCATIONS

PROJECT

WORKS$\_$ON

DEPENDENT

Figure $5\mathrm{.}5$

Schema diagram for the

COMPANY relational

database schema.

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

$($b$)$ Find the names of employees that are directly supervised by 'Franklin Wong' $(2$ points$)$