POS 410 Week 2 Individual Assignment Table Queries


Ask a Question

POS 410 Week 2 Individual Assignment Table Queries

Regular price $15.00

POS 410 Week 2 Individual Assignment Table Queries

 

Instructions: Create an Employee table with the columns listed below to hold the personal data on each employee.  Take a screenshot of the executed code and the results. The employee table will include the following columns:   

  • Employee ID
  • Last name                      
  • First name
  • Address
  • City
  • State
  • ZIP Code
  • Area Code
  • Phone Number
  • Gender
  • DOB
  • Age
  • Hire Date
  • No. of Exemptions (Ex. 0, 1, 2, 3, 4)
  • Marital Status (S, M, HOH)
  • Salary
  • Job ID (Foreign key to Job Title table) Insert records into the Job Title table using the Data Sheet for this assignment. Take a screenshot of the executed code and the results. The data to be inserted in the Employee table can be found on the Employee table data sheet.  Take a screenshot of the executed code and the results. Select all the records in the Job Title Table and display.  Take a screenshot of the executed code and the results. Use the database and tables developed in the Weeks One and Two Individual Assignments to complete the following:   
  • Join two tables in the example database and use BETWEEN to restrict the records based on Salary. Take a screenshot of the executed code and the results.   
  • Join two tables in the example database and use BETWEEN to restrict the records based on Hire Dates. •  Join two tables in the example database and use LIKE to restrict the records based on Telephone Area Codes. Take a screenshot of the executed code and the results.   
  • Join two tables in the example database and use LIKE to restrict the records based on Age. Take a screenshot of the executed code and the results.   
  • Use the UNION of the two tables to produce a third table. Take a screenshot of the executed code and the results. Take screenshots of the successfully executed code and results from each bullet point above and paste them into a Word document. Save all code in a separate Notepad file. Zip all files to prepare for submission. Submit your zipped folder to the Assignment Files tab.

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question