1. Insert into PROJECT.
2. Insert into DEPENDENT.
3. Modify employee 88866555 salary from 55000 to 65000
4. Delete the department tupe with DNumber=4

1. Give relational algebra expressions for the following queries. The queries should be correct for every possible instance of the database.
   1. Retrieve the names of all female employees
   2. Find the names of dependents that depend on employee works for Research department
   3. Retrieve the names of employees who are not department managers
   4. For each employee, retrieve total number of projects he/she works on.

EMPLOYEE LNAME Smith Wong SSN 123456789 333445558 FNAME MINIT John B Franklin T Alicia J Jennifer s Ramesh Joyce A Ahmad v James E Wallace Narayan English Jabbar Borg 987654321 666884644 453453453 987987987 888605555 BOATE 1965-01-09 1956-12-08 1968-07-19 1941-06-20 1962-09-15 1972-07-31 1969-03-29 1937-11-10 ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 321 Caste Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX SEX M M F F M F M M SALARY 30000 40000 25000 43000 38000 25000 25000 55000 SUPERSSN DNO 333445556 5 US 5 987654321 4 888665555 4 333445556 5 333445555 5 987654321 4 1 DEPT_LOCATIONS DNUMBER 1 DLOCATION Houston Stafford Belaire Sugaland Houston 4 5 DEPARTMENT DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988-06-22 1995-01-01 1981-06-19 5 WORKS ON ESSN 123456789 123456789 GBBBBA444 453453453 453453453 333445555 333445556 333445556 303445555 PNO 1 2 3 1 2 2 PROJECT PLOCATION ONUM 3 10 HOURS 325 7.5 400 200 200 100 100 100 100 300 100 350 5.0 200 150 nul PNAME Product Product Product Computerization Reorganization Newbenefits PNUMBER 1 2 3 10 20 30 5 Sugarland Houston Staford Houston 4 987987987 987987987 S879ARI 987654321 888666566 10 10 30 30 20 DEPENDENT ESSN SEX 333445555 333445555 987654321 123456789 123456789 123456789 DEPENDENT NAME Akce Theodore Joy Abner Michael Aloe Elizabeth F M F M M F BOATE 1986-04-05 1983-10-25 1958-05-03 1942.02.28 1988-01-04 1988-12-30 1957-05-05 RELATIONSHIP DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE F