Using the COMPANY database state, express the following queries in relational algebra:

1- Select all female employees. (0.5 point)

2- Select all the employees supervised by the employee whose Social Security Number (SSN) is 333445555. (0.5 point)

3- Select all female employees that work in department 5. (0.5 point)

4- Select all projects controlled by department 5. (0.5 point)

5- Select the dependent name and birth date of all dependents that belong to the employee whose SSN is 333445555. (1 point)

6- Produce a relation showing the employee first name, last name, name of his/her dependent, dependents birth date, and relationship to the employee. (1 point)

Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE DEPARTMENT DEPT_LOCATIONS \begin{tabular}{|l|c|c|c|} \hline \multicolumn{1}{|c|}{ Dname } & Dnumber & Mgr_ssn & Mgr_start_date \\ \hline Research & 5 & 333445555 & 19880522 \\ \hline Administration & 4 & 987654321 & 19950101 \\ \hline Headquarters & 1 & 888665555 & 19810619 \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline Dnumber & Dlocation \\ \hline 1 & Houston \\ \hline 4 & Stafford \\ \hline 5 & Bellaire \\ \hline 5 & Sugarland \\ \hline 5 & Houston \\ \hline \end{tabular} WORKS_ON PROJECT \begin{tabular}{|c|c|c|} \hline Essn & Pno & Hours \\ \hline 123456789 & 1 & 32.5 \\ \hline 123456789 & 2 & 7.5 \\ \hline 666884444 & 3 & 40.0 \\ \hline 453453453 & 1 & 20.0 \\ \hline 453453453 & 2 & 20.0 \\ \hline 333445555 & 2 & 10.0 \\ \hline 333445555 & 3 & 10.0 \\ \hline 333445555 & 10 & 10.0 \\ \hline 333445555 & 20 & 10.0 \\ \hline 999887777 & 30 & 30.0 \\ \hline 999887777 & 10 & 10.0 \\ \hline 987987987 & 10 & 35.0 \\ \hline 987987987 & 30 & 5.0 \\ \hline 987654321 & 30 & 20.0 \\ \hline 987654321 & 20 & 15.0 \\ \hline 888665555 & 20 & NULL \\ \hline \end{tabular} \begin{tabular}{|l|c|l|c|} \hline \multicolumn{1}{|c|}{ Pname } & Pnumber & Plocation & Dnum \\ \hline ProductX & 1 & Bellaire & 5 \\ \hline ProductY & 2 & Sugarland & 5 \\ \hline ProductZ & 3 & Houston & 5 \\ \hline Computerization & 10 & Stafford & 4 \\ \hline Reorganization & 20 & Houston & 1 \\ \hline Newbenefits & 30 & Stafford & 4 \\ \hline \end{tabular} DEPENDENT \begin{tabular}{|c|l|c|c|l|} \hline Essn & Dependent_name & Sex & Bdate & Relationship \\ \hline 333445555 & Alice & F & 19860405 & Daughter \\ \hline 333445555 & Theodore & M & 19831025 & Son \\ \hline 333445555 & Joy & F & 19580503 & Spouse \\ \hline 987654321 & Abner & M & 19420228 & Spouse \\ \hline 123456789 & Michael & M & 19880104 & Son \\ \hline 123456789 & Alice & F & 19881230 & Daughter \\ \hline 123456789 & Elizabeth & F & 19670505 & Spouse \\ \hline \end{tabular}