100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 4 pages.
Directions:a.Use the following text file for table definitions:TBL_1 LOCATIONSTBL_2 DEPARTMENTSTBL_3 EMPLOYEESb.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?