Please pleeeeeaaaase someone do all parts especially 4 & up
Thanks in advance
Using the COMPANY relational database (P72), write the Relational Algebra expression for the following queries: 1) Retrieve all information on female employees. 2) Retrieve the names and date of birth of all employees born before 1960. 3) Retrieve the name and address of all employees who work for the Research department 4) List the names of every manager and the name and number of the department they manage. 5) Find the names and address of all workers who worked on project with Pnos 2. 6) For every project located in Stafford, list the project number, the controlling department number, and the department's manager last name, address and date of birth. 7) Make the list of project numbers for projects in which an employee with name Smith worked either as manager or as a worker and the department that controls each project. 8) List of the names of employees with 2 or more dependents. 9) Retrieve the names of employees with no dependents. 10) List the name and manager's name of the department with the highest number of employees. Draw the query tree for queries (1,2,4,5 and 8) Using the COMPANY relational database (P72), write the Relational Algebra expression for the following queries: 1) Retrieve all information on female employees. 2) Retrieve the names and date of birth of all employees born before 1960. 3) Retrieve the name and address of all employees who work for the Research department 4) List the names of every manager and the name and number of the department they manage. 5) Find the names and address of all workers who worked on project with Pnos 2. 6) For every project located in Stafford, list the project number, the controlling department number, and the department's manager last name, address and date of birth. 7) Make the list of project numbers for projects in which an employee with name Smith worked either as manager or as a worker and the department that controls each project. 8) List of the names of employees with 2 or more dependents. 9) Retrieve the names of employees with no dependents. 10) List the name and manager's name of the department with the highest number of employees. Draw the query tree for queries (1,2,4,5 and 8)