Please apply the following operations using relational algebraic expressions:
1) To show the First Name, Last Name, and Department No. of all male employees.
2) To show all dependents who work on any project for more than 20.0 hours.
3) To show the Address of managers of departments.
4) To show the Project Names that are undertaken by the research department.
5) To show the Project that has consumed the most time till now.
EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno
John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5
Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5
Alicia J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4
Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 888665555 4
Ramesh K Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M 38000 333445555 5
Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX 25000 333445555
Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4
James E Borg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL 1
DEPARTMENT
DEPT_LOCATIONS
Dname Dnumber Mgr_ssn Mgr_start_date Dnumber Dlocation
Houston Stafford Bellaire Sugarland Houston Research Administration Headquarters
5 4 1 333445555 987654321 888665555 1988-05-22 1995-01-01 1 4 5 5 5 1981-06-19
WORKS_ON
PROJECT
Essn Pno Hours
32.5 Pname ProductX ProductY ProductZ Pnumber Plocation
1 Bellaire 2 Sugarland 3 Houston Dnum
123456789 123456789 666884444 1 2 3 1 2 2 5 5 5 7.5 40.0
453453453 20.0 20.0 Computerization Reorganization Newbenefits 10 20 30 Stafford Houston Stafford 4
453453453 333445555 333445555 333445555 1 4 10.0 3 10 20 10.0 10.0 10.0
DEPENDENT
333445555 Essn Dependent_name Sex
F M F M Bdate Relationship
1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse
999887777 30 10 10 30.0 10.0 35.0 5.0
333445555 333445555 Alice Theodore Joy Abner
999887777 987987987 333445555 987987987 30 30
987654321 1942-02-28 Spouse 987654321 987654321 20.0
123456789 123456789 Michael M F F
1988-01-04 Son 1988-12-30 Daughter 1967-05-05 Spouse
20 20 15.0 NULL Alice 888665555 123456789 Elizabeth