Reference no: EM131992033

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