Consider the Employee relation shown in the exhibit.
A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?
A.
CREATE VIEWEmp_Dept AS SELECT
Last_Name, First_Name, Dept_ID FROM
Employee;
B.
UPDATE VIEWEmp_Dept
AS SELECT * FROM
Employee;
C.
UPDATE VIEWEmp_Dept AS SELECT
Last_Name, First_Name, Dept_ID FROM
Employee;
D.
CREATE VIEWEmp_Dept
AS SELECT * FROM
Employee WHERE ID = 0001
AND ID = 0002 AND ID =
0003 AND ID = 0004;