Lab7.docx - Direction Use the Employees Departments and Locations table Codes for these three table are uploaded in the previous topic 1 Create a view

Lab7.docx - Direction Use the Employees Departments and...

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?
Image of page 1
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture