Question

5. Consider the following Relational schema: Employees (E_Id, Name, Salary, D_Id, Mgr_Id) (Where Mgr is also an employee.) Projects (P_Id, P_Name, Description) Works_on (E_Id, P_Id, Hours) Departments (D_Id, Location) Write relational algebra expression for following queries: a) List the name of projects that have employees from research department and working less than 8 hours. b) List the name of employees with a salary more than manager. c) List the name of employees working on two projects with name X and Y. d) List the name of employees having salary more than Rs. 50,000 and does not work on any project. (4)

          5. Consider the following Relational schema:
Employees (E_Id, Name, Salary, D_Id, Mgr_Id)
(Where Mgr is also an employee.)
Projects (P_Id, P_Name, Description)
Works_on (E_Id, P_Id, Hours)
Departments (D_Id, Location)
Write relational algebra expression for following queries:
a) List the name of projects that have employees from research
department and working less than 8 hours.
b) List the name of employees with a salary more than
manager.
c) List the name of employees working on two projects with
name X and Y.
d) List the name of employees having salary more than Rs.
50,000 and does not work on any project.
(4)

5. Consider the following Relational schema:
Employees (EId, Name, Salary, DId, MgrId)
(Where Mgr is also an employee.)
Projects (PId, PName, Description)
Workson (EId, PId, Hours)
Departments (DId, Location)
Write relational algebra expression for following queries:
a) List the name of projects that have employees from research
department and working less than 8 hours.
b) List the name of employees with a salary more than
manager.
c) List the name of employees working on two projects with
name X and Y.
d) List the name of employees having salary more than Rs.
50,000 and does not work on any project.
(4)

Added by Blanca G.

Question

Please give Ace some feedback