Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allo

[answerhappygod]

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?

Consider The Em 1 (160.19 KiB) Viewed 72 times

A. CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
B. UPDATE VIEW Emp_Dept AS SELECT * FROM Employee;
C. UPDATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID FROM Employee;
D. CREATE VIEW Emp_Dept AS SELECT * FROM Employee WHERE ID = 0001 AND ID = 0002 AND ID = 0003 AND ID = 0004;