Practice 11 Part 1 1. The staff in the HR department wants to hide some of the data in the EMPLOYEES table. They want a view called EMPLOYEES_VU based on the employee numbers, employee names, and...


Practice 11<br>Part 1<br>1. The staff in the HR department wants to hide some of the data in the EMPLOYEES table.<br>They want a view called EMPLOYEES_VU based on the employee numbers, employee<br>names, and department numbers from the EMPLOYEES table. They want the heading for<br>the employee name to be EMPLOYEE.<br>2. Confirm that the view works. Display the contents of the EMPLOYEES_VU view.<br>EMPLOYEE D EMPLOYEE<br>DEPARTMENT ID<br>1<br>100 King<br>90<br>2<br>101 Kochhar<br>3<br>102 De Haan<br>90<br>4<br>103 Hunold<br>60<br>104 Ernst<br>60<br>19<br>205 Higgins<br>110<br>20<br>206 Gietz<br>110<br>3. Using your EMPLOYEES_VU view, write a query for the HR department to display al<br>employee names and department numbers.<br>dem<br>EMPLOYEE E DEPARTMENT_ID<br>8 8 8 8<br>

Extracted text: Practice 11 Part 1 1. The staff in the HR department wants to hide some of the data in the EMPLOYEES table. They want a view called EMPLOYEES_VU based on the employee numbers, employee names, and department numbers from the EMPLOYEES table. They want the heading for the employee name to be EMPLOYEE. 2. Confirm that the view works. Display the contents of the EMPLOYEES_VU view. EMPLOYEE D EMPLOYEE DEPARTMENT ID 1 100 King 90 2 101 Kochhar 3 102 De Haan 90 4 103 Hunold 60 104 Ernst 60 19 205 Higgins 110 20 206 Gietz 110 3. Using your EMPLOYEES_VU view, write a query for the HR department to display al employee names and department numbers. dem EMPLOYEE E DEPARTMENT_ID 8 8 8 8

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here