SQL- creating tables in existing database, assignment help

REQUIRED: Prepare ALL Code per the Coding Standards document and save in One (1) Notepad file all each code set in the order to be executed. Refer to the materials – Coding Standards for POS 410 – before proceeding with this assignment.

Check all code against the Grading Rubric in Materials with this assignment.

NOTE: This is a large assignment. It is strongly recommended to start early in the week and take time to post code for a review and assistance in a Private message to help prepare it accurately and completely and not wait until the day it is due to begin the work.

REQUIRED: Using the Database created in Week 1, add 2 tables to the Database and required inserts from the Week 2 Data Sheet Kudler Fine Foods. Datasheet is attached materials to this assignment.

Week 2 Individual Assignment. The following is a list of columns for each table and the connections (keys) that you will manually create by writing the SQL.

REQUIRED: ALL code must be commented. See Tutorial for writing comments for each code set.

Assignment Request: Create the Job Title table per guidelines listed below.

REQUIRED: The JobTitle table name must be preceded by “tbl”, (for example tblTableName) in order to receive full credit consideration.

REQUIRED: ALL code must be commented. See Tutorial for writing comments for each code set.

REQUIRED: The Job Title table column names must be preceded by “job”, (for example jobJobCode), in order to receive full credit consideration.

Columns that will be needed in the Job Title table are as follows (there are 5 columns total):

Job Title Table

• Job ID
• Job Classification
• Title
• Description
• Status (exempt or non-exempt)

REQUIRED: Create the Code, Execute the code without errors, then take a screen shot of the code and message showing “Command(s) completed successfully.”

REQUIRED: Save the code in a NotePad file, paste the screen shots in a Word Document.

Assignment Request: Insert the 9 job title records from the Week 2 Data sheet into the Job Title table.

REQUIRED: ALL code must be commented. See Tutorial for writing comments for each code set.

Use the SQL INSERT statement from the Kudler Fine Foods Data Sheet for exact data to insert – See DATA: Required Inserts – attached.

REQUIRED: Create the Code, Execute the code without errors, then take a screen shot of the code and message showing “# of row(s) affected.”

REQUIRED: Save the code in your NotePad file created for this week, paste the screen shots in your Word Document created for this week.

Assignment Request: Create the Employee table per guidelines listed below.

REQUIRED: ALL code must be commented. See Tutorial for writing comments for each code set.

REQUIRED: The Employee table name must be preceded by “tbl” (for example, tblTableName) in order to receive full credit consideration.

REQUIRED: Employee table columns must all be preceded by “emp” (for example, a column name must look like the following: empLastDay) in order to receive full credit consideration.

Columns that will be needed in the Employee table are as follows (there are 18 columns total):

• Employee Table
  • Employee ID
  • Last name
  • First name
  • Address
  • City
  • State
  • ZIP Code
  • Area Code
  • Phone Number
  • Gender
  • DOB
  • Age
  • Hire Date
  • No. of Exemptions (Ex. 0, 1, 2, 3, 4)
  • Marital Status (S, M, HOH)
  • Salary
  • Store ID (Foreign Key to the Store Table)
  • Job ID (Foreign key to Job Title table)

REQUIRED: Create the Code, Execute the code without errors, then take a screen shot of the code and message showing “Command(s) completed successfully.”

REQUIRED: Save the code in your NotePad file created for this week, paste the screen shots in your Word Document created for this week.

Assignment Request: Insert the 7 employee records from the Week 2 Data sheet into the Employee table – See DATA: Required Inserts – attached!

REQUIRED: ALL code must be commented. See Tutorial for writing comments for each code set.

REQUIRED: Create the Code, Execute the code without errors, then take a screen shot of the code in the current screen and message showing “# of row(s) affected.”

REQUIRED: Save the code in your NotePad file created for this week, paste the screen shots in your Word Document created for this week.

Assignment Request: Check results by selecting all columns from both tables.

REQUIRED: Create the Code, Execute the code without errors, then take a screen shot of your results to submit with the assignment. Use this code:

SELECT *

FROM TableName

Assignment Request: Create a Data Dictionary

REQUIRED: Use the attached Data Dictionary Template. A sample Data Dictionary may be found in the “How to create the week 2 individual assignment” instructions. Remember to cover all three (3) tables in the data dictionary.

WHAT TO SUBMIT:

Review the Grading Rubric before you upload and submit the Assignment.

Note: There will be two (3) Attachments for this assignment (Please DO NOT ZIP files)

Submit only One (1) Notepad attachment with “all” code and One (1) Word document with all screenshots and One (1) Data Dictionary.

Notepad file includes code in this order:

• Create Table code for creating the Job Title table
• Create Table code for creating the Employee table
• Insert Code for adding the records to the Job Title table
• Insert Code for adding the records to the Employee table
• SELECT code for the Job Title table
• SELECT code for the Employee table

(NOTE: submitting only 1 record in your INSERT statement for any table will result in loss of points and request to resubmit.)

Word Document includes screen shots of the executed code (without errors) in this order:

• Screen shot of the execution of the code to create the Job Title table
• Screen shot of the execution of the code to create the Employee table
• Screen shot of the code to insert the records into the Job Title table
• Screen shot of the code to insert the records into the Employee table
• Screen shot of the code and table results from selecting the Job Title table

• Screen shot of the code and table results from selecting the Job Title table

Note: There will be three (3) Attachments on the Assignments page (Notepad file with Code, Document with Screenshots, Data Dictionary).

 

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"