I am needing help with relational algebra

16 points] 8.16. Specify the following queries on the COMPANY relational database schema shown in Figure 5.5 using the relational operators discussed in this chapter. Also show the result of each query as it would apply to the database state in Figure 5.6 [6 points] 8.22. Consider the two tables TI and T2 shown in Figure 8.15. Show the results of the following operations: Retrieve the names of all employees in department 4 who work more than 10 hours per week on the ProductX project. a. T2 c. TITIP T2.A T2 b. List the names of all employees who have a dependent with the same first name as themselves. Find the names of all employees who are directly supervised by Jennifer Wallace e. TI U T2 d. For each project, list the project name and the total hours per week (by all employees) spent on that project. (T1.P = T2.A AND T1.R = T2.C) e. Retrieve the names of all employees who work on every project f. Retrieve the names and SSN of all employees who do not work on any project. g. For each department, retrieve the department name and the highest salary of all employees Figure & 15 A database stabe for the relations T1 and T2 TABLE T1 TABLE T2 working in that department Retrieve the average salary of all female employees per department. 10 a 5 15 b 8 25 a 6 10 b 6 25 3 10 b 5 h. EMPLOYEE Bdate Addreas Se DEPARTMENT Dname san DEPT LOCATIONS PROJECT Pname Plocation Dnum WORKS ON Hours Figure 5.5 Schema dagram for the COMPANY relational database schema DEPENDENT