Question: Relational algebra question 30 points] Consider the Question.7 following relations EMPLOYEE(e-id, ename, salary, address, d-id) DEPARTMENT(d-id, manager-id) where the manager of a department is also
Relational algebra question
![Relational algebra question 30 points] Consider the Question.7 following relations EMPLOYEE(e-id, ename,](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f3b912748e2_65766f3b911d7cfe.jpg)
30 points] Consider the Question.7 following relations EMPLOYEE(e-id, ename, salary, address, d-id) DEPARTMENT(d-id, manager-id) where the manager of a department is also an employee. Provide a Relational Algebra expression for each of the following queries: (a) [5 points] Return all the pairs of employee id and the corresponding manager id. (b) [10 points] Return all the pairs of employee name and the corresponding manager name. (c) [10 points] Return the id of the employees who have a salary higher than the salary of their managers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
