translate into relational algebra

it does not offer me more tgan that

ROM E OW-C150/450/FTP/Assignments/Questions/db-questions relo.php Group 1 Questions // Also show name as an emplo dependents who he Il Question 1. List the names of dependents who have the // same first name as an employee of whom they are not the dependent Il Also show the son of the employee with the same first name and the son Il of the employee on whom the dependent is dependent (dependent.essn). Il (All of this should be shown in the same table.) Display results in Il order by dependent.essn within dependent name. II Column Headings: DEPENDENT_NAME DEP_EMP_SSN OTHER_EMP_SSN Il Question 2. For each department, display the average // salary of supervisors in the department, showing the department name ll and the average supervisor salary. [A supervisor is considered to be // in a department if his/her DNO matches that of the department. He/she Il does not have to supervise someone in the department.) Display results Il in order by department name. II Column Headings: DNAME AVG_SALARY Il Question 3. Retrieve the first and last names of Il employees who work on projects which are not controlled by their Il departments. Also show the names of the projects, the employee's Il department number, and the number of the project's controlling Il department. (All of this should be shown in the same result table.) // Display results in order by last name and then first name and then Il project name gunent Note: Click on the assignment title beloy Some links below may be unavailab appropriate time in the semes Syllabus Assignment Assignment 1: Relational Algebra See schedule for due date. The assignment Available: 1/27/2020 Resources for this module. Relational Algebra Online Develop your Relational Algebra Questions against a database. Relational Algebra Online (type only) An alternative version without some of the annoyances, but you have to type everything Relational Algebra Batch Processor Use this before submitting to check your algebra.txt file. This processor runs a file of Relational Algebra output and errors. Each question must have RESULT as the last relation You can submit your Relational Algebra assignment via the web or submit it using the linux submit pr Do not submit archives or compressed files (.zip. .rar, etc.). They will not be graded. Move all files to be submitted to a directory by themselves before using Linux submit AY ROM E OW-C150/450/FTP/Assignments/Questions/db-questions relo.php Group 1 Questions // Also show name as an emplo dependents who he Il Question 1. List the names of dependents who have the // same first name as an employee of whom they are not the dependent Il Also show the son of the employee with the same first name and the son Il of the employee on whom the dependent is dependent (dependent.essn). Il (All of this should be shown in the same table.) Display results in Il order by dependent.essn within dependent name. II Column Headings: DEPENDENT_NAME DEP_EMP_SSN OTHER_EMP_SSN Il Question 2. For each department, display the average // salary of supervisors in the department, showing the department name ll and the average supervisor salary. [A supervisor is considered to be // in a department if his/her DNO matches that of the department. He/she Il does not have to supervise someone in the department.) Display results Il in order by department name. II Column Headings: DNAME AVG_SALARY Il Question 3. Retrieve the first and last names of Il employees who work on projects which are not controlled by their Il departments. Also show the names of the projects, the employee's Il department number, and the number of the project's controlling Il department. (All of this should be shown in the same result table.) // Display results in order by last name and then first name and then Il project name gunent Note: Click on the assignment title beloy Some links below may be unavailab appropriate time in the semes Syllabus Assignment Assignment 1: Relational Algebra See schedule for due date. The assignment Available: 1/27/2020 Resources for this module. Relational Algebra Online Develop your Relational Algebra Questions against a database. Relational Algebra Online (type only) An alternative version without some of the annoyances, but you have to type everything Relational Algebra Batch Processor Use this before submitting to check your algebra.txt file. This processor runs a file of Relational Algebra output and errors. Each question must have RESULT as the last relation You can submit your Relational Algebra assignment via the web or submit it using the linux submit pr Do not submit archives or compressed files (.zip. .rar, etc.). They will not be graded. Move all files to be submitted to a directory by themselves before using Linux submit AY