Here is the database state. answer questions using this state.

Using relational algebra operations, construct queries that satisfies provided descriptions.

a. Retrieve first name and last name of all male employees with salary more than 30000.

b. Retrieve locations of Research department projects.

c. Retrieve first name, last name, and SSN of all employees who work more than 9 hours on project 2.

d. Retrieve name, date of birth and relationship of all female dependents of employees who work for department 5.

WORKS ON PROJECT EMPLOYEE Sex Salary Super_ssn Dno Pnumber Essn Ssn Pno Plocation Fname Minit Lname Bdate Address Hours Pname Dnum 123456789 1965-01-09 731 Fondren, Houston, TX M 333445555 1955-12-08 638 Voss, Houston, TX 30000 333445555 B Smith 123456789 32.5 ProductX Bellaire John 40000 888665555 123456789 Sugarland ProductY Franklin 7.5 Wong 25000 987654321 999887777 1968-01-19 3321 Castle, Spring, TX Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M English 453453453 1972-07-31 5631 Rice, Houston, TX 987987987 1969-03-29 980 Dallas, Houston, TXx 666884444 40.0 Productz 3 Houston 5 Alicia Zelaya 4 453453453 Stafford 43000 888665555 20.0 Computerization 10 4 Jennifer Reorganization 453453453 20.0 Houston Ramesh K 38000 333445555 333445555 Newbenefits Stafford 10.0 30 25000 333445555 A Joyce 333445555 10.0 3 Ahmad Jabbar 25000 987654321 4 333445555 10.0 10 DEPENDENT 1937-11-10 450 Stone, Houston, TX 55000 NULL James Borg 888665555 333445555 20 10.0 Dependent_name Essn Sex Bdate Relationship DEPT LOCATIONS 999887777 30 30.0 DEPARTMENT Alice 1986-04-05 Daughter 333445555 10 999887777 10.0 Dlocation Dnumber Dnumber Mgr_ssn 333445555 Theodore 1983-10-25 Son Dname Mgr_start_date 10 35.0 987987987 333445555 Joy 1958-05-03 Spouse Research Houston 333445555 1988-05-22 987987987 30 5.0 1942-02-28 Spouse 987654321 Abner Stafford Administration 987654321 1995-01-01 30 987654321 20.0 Bellaire 123456789 Michael 1988-01-04 Son Headquarters 888665555 1981-06-19 987654321 20 15.0 Daughter Sugarland 123456789 Alice 1988-12-30 888665555 Elizabeth Spouse Houston 20 NULL 123456789 1967-05-05