Lab5.docx - Directions a Use the following text file for table definitions TBL_1 LOCATIONS TBL_2 DEPARTMENTS TBL_3 EMPLOYEES b Populate the three tables

Lab5.docx - Directions a Use the following text file for...

This preview shows page 1 - 2 out of 4 pages.

Directions: a. Use the following text file for table definitions: TBL_1 LOCATIONS TBL_2 DEPARTMENTS TBL_3 EMPLOYEES b.Populate the three tables with following values found on the 3 text file:TBL_1 LOCATIONS VALUESTBL_2 DEPARTMENTS VALUESTBL_3 EMPLOYEES VALUESc.In each number, write the SQL statement that you use in order for you to comeup with the right answer. Answer with no SQL statements will not be credited.d.Answer the questions ask in each numbers.1.Create a report that will display the following: DEPARTMENT_NAME,MANAGER_ID, LOCATION_ID and POSTAL CODE. Use natural join to get the datafrom two table.Question: What is the Postal Code of employee under the Marketing department? 2.Create a report that will display the following: concatenated column of LASTNAMEand FIRSTNAME put a literal charter string in between 2 columns ‘,’ rename thecolumn as FULL NAME. Also get the DEPARTMENT_ID and LOCATION_ID. Usenatural join to get the data from two table.Questions: What is/are the full name of employee whose LOCATION_ID is equal to1700?
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture