Hi everyone,

Please I'd love to have correct answers to these questions by providing typed clear answer capable of being copied to a word file so I can apply it in the program to see outcomes(if needed)!

Please do your best or leave it to someone else if you think you can't fulfill all parts required.

I really will appreciate the one who take care of this as I always do with everybody's else :)

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)