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