Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table's primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.
DO NOT CREATE THE TABLE USING THE GUI INTERFACE of the Management Studio or any other tool. You must write your own CREATE TABLE statement. This will be evident if you do.
• Employee
§ Emp_ID
§ Last_name
§ First_name
§ Address
§ City
§ State
§ Telephone_area_code
§ Telephone_number
§ EEO-1 Classification
§ Hire_date
§ Salary
§ Gender
§ Age
§ Foreign Key from Job Title table
• Job_title
§ EEO-1 Classification
§ Job_title
§ Job description
§ Exempt / Non-Exempt Status
Using the SQL INSERT statement:
• Go to the Human Resources department in the Kudler Fine Foods intranet. Using information found in the Employee Files for the La Jolla and Encinitas stores, enter records into the employee table for the following employees:
§ Glenn Edelman
§ Eric McMullen
§ Raj Slentz
§ Erin Broun
§ Donald Carpenter
§ David Esquivez
§ Nancy Sharp
• Using the Kudler Fine Foods Job Classifications and Job Descriptions information, enter records into the job_title table for the following job titles:
§ Accounting Clerk
§ Asst. Manager
§ Bagger
§ Cashier
§ Computer Support Specialist
§ Director of Finance & Accounting
§ Retail Asst. Bakery & Pastry
§ Retail Asst. Butchers and Seafood Specialists
§ Stocker
Non-Exempt employees at Kudler Fine Foods are paid an. Exempt employees are paid at the rate of an annual salary. Exempt employees do not earn overtime pay.
Check the results by selecting all of the columns from both of your tables.
Submit all of the SQL statements you used to:
• Create the tables requested above.
• Load the data into the tables
• Check the results
You should submit your assignment as a posting to your Individual Forum by 11:59 PM Mountain Time on Day 7 (Monday) of Week 2.
The assignment should consist of two file attachments to your posting:
1. The SQL statements should be copied into a Microsoft Word document (doc or docx) or a text file with the txt extension. You should submit one file that contains all of the statements. The statements should include ALL of the SQL you wrote to:
a. Create the tables requested above.
b. Load the data into the tables
c. Check the results
2. A backup of the database you created. It should include all tables you created. You may zip (compress) this file.