Question: Please pleeeeeaaaase someone do all parts especially 4 & up Thanks in advance Using the COMPANY relational database (P72), write the Relational Algebra expression for

Please pleeeeeaaaase someone do all parts especially 4 & up
Thanks in advance  Please pleeeeeaaaase someone do all parts especially 4 & up Thanks

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)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!