Download the attached Word Document Template named “Lastname – Lab 1.doc”. (change Lastname to your last name)
*** ATTENTION! ***
USE THE ATTACHED WORD DOCUMENT TEMPLATE WHEN YOU TURN IN YOUR ASSIGNMENT
Create a SQL Server Database.
Create the following two tables using the following fields:
(Note: Supply the SQL Server data types when creating the tables. Apply a primary key to each table.)
Employee
Social_Security_Number
• Last_Name
• First_Name
• Address
• City
• State
• Zip_Code
• Telephone_Area_Code
• Telephone_Number
• Email_Address
• Job_Title_Code
• Hire_Date
• Salary
Job_title
Job_Title_Code
• Job_Title
• Exempt (holds exempt status which is either 1 or 0)
• Minimum_Salary
• Maximum_Salary
Using the SQL INSERT statement:
o Enter ten records into the employee table.
o Enter five records into the job_title table.
Include all SQL statements (i.e create, insert, etc used to complete each task of your assignment. Do not include screenshots – rather copy/paste the SQL scripts in the Word document template attached.
Click the Assignment Files tab to submit your assignment.
