POS 410 Week 2 Lab One

********************************************** 
POS 410 Entire Course Link
 
https://uopcourses.com/category/pos-410/
 
**********************************************

POS 410 Week 2 Lab One
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.
Powered by