Write the following in relational algebra (the database sheet is attached
1. List the ssn, fname, lname of employees who do not work in the Administration or Headquarters department (do not use a set operation).
2. Retrieve the average salary and number of of employees who were are male.
3. Same as 4. but list the results for each department by dname, dnumber
4. For each employee, list the employee's firstname, last name and bdate of the employee's dependents (renamed as Dep_Bday) . If an employee does not have a dependent, the employee should still be listed.
5. List the dnumber of departments that have locations in all the same locations as department 5.
