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,

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

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!