Question: Consider the following four linked relations and choose the SQL that answers the given question Employee(empid. I_namel_name, hire_date, job_title, salary, dept_id) Department(dept id dept_name, manager,

Consider the following four linked relations and choose the SQL that answers the given question Employee(empid. I_namel_name, hire_date, job_title, salary, dept_id) Department(dept id dept_name, manager, location) Project(proj id, title, dept_id, start_date) Partof(emp id, proj id, start_date, end_date) Which SQL statement will find all employees names who have been part of all projects belonged to th Engineering department? a. Select E.f_name, E.I_name from employee as E where not exists ((select proj_id from project, department where project.dept_id = department.dept_id and department.dept_name'Engineering') and exists(select P.proj_id from partof as P where E.emp_id P.emp_id)) Ob Select Ef_name, E.l_name from employee as E where not exists (select proj_id from project, department where project.dept_id = department dept_id and department dept_name_>'Engineering) except (select P.proj_id from partof as P where temp_id = Pemp_id)) Select Efname, E.l_name from employee as E where not exists (select proj_id from project, department where project.dept_id = department dept_id and department dept_name'Engineering) and exists (select P proid from partoras P
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
