Question 1. (16 points) Exercise 6.16 (a, c, e and i) on pages 281 - 282. Specify the follow- ing queries on the COMPANY relational database schema shown in Figure 5.5 using the relational algebra operators. Aslo show the result of each query as it would apply to the database state of Figure 5.6. a. Retrieve the names (first and last names) of all employees in department 5 who work more than 10 hours per week (i.e., WORKS_ON.HOURS > 10) on the ProductX' project. c. Find the names of all employees who are directly supervised by Franklin Wong'. e. Retrieve the names of all employees who work on every project. i. Find the names and addresses of all employees who work on at least one project located in Houston but whose (employee's) department has no location in Houston. EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation | Dnum WORKS ON Essn Pno Hours DEPENDENT Figure 5.5 Schema diagram COMPANY relatic database schema | Essn | Dependent_name | Sex | Bdate Relationship