POS 410 Week 2 Lab One | eBooks | Education

POS 410 Week 2 Lab One

POS 410 Week 2 Lab One PLDZ-2381 Instant Download Price
In Stock
$ 7.99 USD
UopTutorialStore
Buy and Download Description

POS 410 Week 2 Lab One

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.

POS 410 Week 2 Lab One 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)
Recent Reviews Be the first to Review this product!
0 0 0 0 reviews