PLEASE COMPLETE ALL

Question 1 (30 points) Consider the following schemas: Employees (eid, ename, age) * WorkOn (eid, pid, hours) Projects (pid, pname, mgr_eid) The key fields are bold and underlined. WorkOn.eid refers to Employees.eid WorkOn.pid refers to Projects.pid. * Projects.mgr_eid refers to Employees.eid. Let E be Employees, let W be WorkOn, and let P be Projects Write Relational Algebra for the following queries. 1) (6 points) List employee's names and their manager's names 2) (6 points) List the names of employees who never worked in the 'Database' project 3) (6 points) List the names of employees who had worked in both Database' project and 4) 5) DataMining' project. (6 points) List the names of managers who managed more than one project. (6 points) List the names of projects which are worked by all employees