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 TableJob IDJob Classification Title DescriptionStatus (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 TableEmployee IDLast name First nameAddress City StateZIP CodeArea Code Phone Number GenderDOBAgeHire Date No. of Exemptions (Ex. 0, 1, 2, 3, 4)Marital Status (S, M, HOH)SalaryStore 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 TableNameAssignment Request: Create a Data DictionaryREQUIRED: 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 tableCreate Table code for creating the Employee tableInsert Code for adding the records to the Job Title tableInsert Code for adding the records to the Employee tableSELECT code for the Job Title tableSELECT 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 tableScreen shot of the execution of the code to create the Employee tableScreen shot of the code to insert the records into the Job Title tableScreen shot of the code to insert the records into the Employee tableScreen shot of the code and table results from selecting the Job Title tableScreen 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).




Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.