POS 410 Week 2 Lab One

Download the attached Word Document Template named “Lastname – Lab 1.doc”. (change Lastname to your last name)

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