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?
