100%(8)8 out of 8 people found this document helpful
This preview shows page 1 - 3 out of 7 pages.
Direction: Use the Employees, Departments and Locations table. Codes for these three tableare uploaded in the previous topic. 1.Create a view and name as EMPVIEWSAL get the column EMPLOYEE_ID, LASTNAMEand SALARY from employees table and put a condition where SALARY is between 5000and 10000Who are the employees include in the EMPVIEWSAL view?2.Add a new data in EMPVIEWSAL as shown below:103DE GUZMAN4000Is inserting Mr. De Guzman successful? To what table were you able to insert therecord of Mr. De Guzman? Explain the reason why?