Create an employee table with the columns listed below to


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. T

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Create an employee table with the columns listed below to
Reference No:- TGS02778498

Now Priced at $20 (50% Discount)

Recommended (96%)

Rated (4.8/5)