Question 1 (30 points) Consider the following schemas: Employees (eid, ename, age) 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 DataMining' project. 4) (6 points) List the names of managers who managed more than one project. 5) 6 points) List the names of projects which are worked by all employees. Question 1 (30 points) Consider the following schemas: Employees (eid, ename, age) 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 DataMining' project. 4) (6 points) List the names of managers who managed more than one project. 5) 6 points) List the names of projects which are worked by all employees