Given the following COMPANY relational database state, please display the result of each query specified by a relational algebra expression.

a.SELECT_{Dno = 5 AND Salary >= 25000}(EMPLOYEE)

b.PROJECT_{Essn, Relationship} (DEPENDENT).

c.PROJECT_Ssn(EMPLOYEE) PROJECT_Essn(DEPENDENT)

d.PROJECT_{Mgr_ssn}(DEPARTMENT) UNION PROJECT_Essn(DEPENDENT)

e.PROJECT_{Essn, Pno}(WORKS_ON) / PROJECT_Pno( SELECT_{Essn = 123456789}(WORKS_ON))

f.PROJECT_{Super_ssn}(EMPLOYEE)

g.F_{AVERAGE(Salary)} (EMPLOYEE)

h._EssnF_MAX(Hours) (WORKS_ON)

i._{Dno, Sex}F_COUNT(*)(EMPLOYEE)

Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Fname Minit Lname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 888665555 5 Alicia Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 JenniferS 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 F 25000 333445555 5 Ssn Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Ahmad V Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX M 25000 987654321 4 James EBorg 888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnumber Dnumber Mgr start date 1988.05-22 1995-01-01 1981-06-19 Dlocation Houston Stafford Bellaire Sugarland Houston Dname Research Administration Headquarters Mgr ssn 333445555 987654321 888665555 4 WORKS ON PROJECT ssn Pnumber Plocation Dnum ProductX ProductY ProductZ Computerization Reorganization Newbenefits 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 32.5 Sugarland Houston Stafford Houston Stafford 5 20.0 20 4 DEPENDENT 20 10.0 30 30.0 10 10.0 ndent name Sex Bdate Relationship 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 123456789 Michael 123456789Alice 123456789Elizabeth F 1986-04-05 Daughter M 1983-10-25 Son F 1958-0503 Spouse M 1942-02-28 Spouse M 1988-01-04 Son F 1988-12-30 Daughte F 1967-05-05 Spouse 30 20.0 98765432120 150 20 NULL 888665555