POS 410 ENTIRE COURSE


Ask a Question

POS 410 ENTIRE COURSE

Regular price $50.00

POS 410   ENTIRE COURSE
 
 
WEEK  1

POS 410 Week 1 Individual Assignment Create a Database

 

Instructions: All of the Individual Assignments in this class will revolve around the following database.  Each week, your assignment will be to complete a different aspect of the database. You have been asked to create a database for the HR department of your company.  Your first assignment is to create a set of tables that will manage employees and their job titles. Each table should have a primary key that is automatically generated and any foreign keys that will be used to join tables together.  You should choose appropriate data types for fields based on the kind of data they will store. Ensure your small database is normalized to at least the third normal form. Create a database to contain the tables for this assignment.  Name the Database with the first four letters of your last name and "database", example:  GARR Database. Take a screenshot of the executed code and the results. Create a Job Title table to hold the data for the different job titles in the company.  Take a screenshot of the executed code and the results. The Job Title table will have the following columns:   

  • Job ID
  • Job Classification
  • Job Title
  • Job Description
  • Status Insert records into the Job Title table using the Data Sheet for this assignment. Take a screenshot of the executed code and the results. The data to be inserted in the Job Title table can be found on the Job Title Data Sheet provided. Select all the records in the Job Title Table and display.  Take a screenshot of the executed code and the results. Take screenshots of the successfully executed code and copy into a Word document.

 

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:    1.  A title page including your name. Your name should also be included in the header of the documents.        1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.    2.  All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.    3.  Copy and paste the results, or provide a screen shot of the resulting views. (Select *)    4.  Results will include the execution status statement results    5.  A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

WEEK  2

 

POS 410 Week 2 Learning Team Assignment Project Plan

 

Instructions: Create the Team's project Plan by filling in the details of the Project Plan Template for all tasks to be completed for each week.  Team members need to volunteer for tasks.  Each team member is required to write a portion of the SQL for the team assignment each week. Create the Team Database and name it TeamNameChartOfAccounts. Create a table named Accounts with the following columns:   

  • Account No.
  • Account Type
  • Short Description
  • Long Description
  • Balance

 

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:    1.  A title page including your name. Your name should also be included in the header of the documents.        1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.    2.  All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.    3.  Copy and paste the results, or provide a screen shot of the resulting views. (Select *)    4.  Results will include the execution status statement results    5.  A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

POS 410 Week 2 Individual Assignment Table Queries

 

Instructions: Create an Employee table with the columns listed below to hold the personal data on each employee.  Take a screenshot of the executed code and the results. The employee table will include the following columns:   

  • 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   

  • Job ID (Foreign key to Job Title table) Insert records into the Job Title table using the Data Sheet for this assignment. Take a screenshot of the executed code and the results. The data to be inserted in the Employee table can be found on the Employee table data sheet.  Take a screenshot of the executed code and the results. Select all the records in the Job Title Table and display.  Take a screenshot of the executed code and the results. Use the database and tables developed in the Weeks One and Two Individual Assignments to complete the following:   
  • Join two tables in the example database and use BETWEEN to restrict the records based on Salary. Take a screenshot of the executed code and the results.   
  • Join two tables in the example database and use BETWEEN to restrict the records based on Hire Dates. •  Join two tables in the example database and use LIKE to restrict the records based on Telephone Area Codes. Take a screenshot of the executed code and the results.   
  • Join two tables in the example database and use LIKE to restrict the records based on Age. Take a screenshot of the executed code and the results.   
  • Use the UNION of the two tables to produce a third table. Take a screenshot of the executed code and the results. Take screenshots of the successfully executed code and results from each bullet point above and paste them into a Word document. Save all code in a separate Notepad file. Zip all files to prepare for submission. Submit your zipped folder to the Assignment Files tab.

 

WEEK  3

POS 410 Week 3 Learning Team Assignment Create Database/Tables/Inserts

 

Instructions: Add the records from the data sheet for Week Three.  Split the records between all team members so each team member is writing a portion of the SQL code for this week.  Each team member needs to execute the code creating the database, the table, and the final result set.  Take screenshots of the fully executed code. Each student to create the full database with everyone's records. Select all the records in the Chart of Accounts Table and display.  Take a screenshot of the executed code and the results. Update the Team Project Plan with who did each task for this week and submit with the Week Three assignment.

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:    1.  A title page including your name. Your name should also be included in the header of the documents.        1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.    2.  All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.    3.  Copy and paste the results, or provide a screen shot of the resulting views. (Select *)    4.  Results will include the execution status statement results    5.  A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

POS 410 Week 3 Individual Assignment Data Changes and SQL Statements

 

Instructions: Complete the following sections of "Windows Server Pro: Install and Configure" in TestOut Instructions: Enter new records into the Employee and the Job Title tables for workers identified in the Week Three Data Sheet in the materials.  Take screenshots of the fully executed code. Select the records from the Job Title Table and display all the records. Take a screenshot of the code and the output display. Select the records from the Employee Table and display all the records.  Take a screenshot of the code and the output display. Use the database and tables developed in the Weeks One, Two, and Three Individual assignments to complete the following:   

  • Increase all employees' salaries with the selected EEO-1 classification by 5.5% percent.
  • Increase all other employees' salaries by 4.9% percent.
  • Choose an employee from the Employee table and delete that employee.
  • Alter the Job Title table to change all job titles from "Bagger" to "Customer Representative".
  • Alter the Job Title table to change all job titles from "Cashier" to "Checker".
  • Using the HAVING command, how many positions have more than 2 employees? (e.g. Checker, 3).

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.   
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results  
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

WEEK  4

POS 410  Week 4 Individual Assignment Add Records/ Query Database

Instructions: Add the records from the data sheet for Week Four.  Split the records between all team members so each team member is writing a portion of the SQL code for this week.  Each team member is to execute the code creating the database, the table, and the final result set. Create Queries against the Team Database. Each team member is required to write one of the queries and execute it successfully. The queries are as follows:   

  • Query One: Create one account number query that uses LIKE or BETWEEN to display a number of Account Numbers in one result set. This account number query should add a column in the query that parses out and displays the first two digits of the account number using SUBSTRING and CONVERT (if required). Execute the code and take a screenshot of the code and the results. Note: The query will display all fields (account number, store name, short description, long description, balance, and any others you may have added. If you have more than one table, you will need to JOIN the tables to include columns from each table) using the account number to filter the results of the query.   
  • Query Two: Create one query that displays all the information in the tables based on one of the Short Descriptions. This query should add a column in the one query that parses out and displays the first 2 digits of the account number using SUBSTRING and CONVERT (if required). Execute the code and take a screenshot of the code and the results. Note: The query will display all fields (account number, store name, short description, long description, balance, and any others you may have added. If you have more than one table, you will need to JOIN the tables to include columns from each table) using one store name of your choice to filter the results of the query.   
  • Query Three: Create one query that displays all the information you entered in the tables based on one of the Short Description and "inventory." This query should add a column in the one query that parses out and displays the first 2 digits of the account number using SUBSTRING and CONVERT (if required). Execute the code and take a screenshot of the code and the results. Note: The query will display all fields (account number, store name, short description, long description, balance, and any others you may have added. If you have more than one table, you will need to JOIN the tables to include columns from each table) using one store name of your choice and "inventory" to pull out all the inventory records for that store to filter the results of the query.   
  • Query Four: Create one query that displays all the information you entered in the tables based on the description of Meat & Seafood and ORDER BY Long Description. This query should add a column in the one query that parses out and displays the first 2 digits of the account number using SUBSTRING and CONVERT (if required). Execute the code and take a screenshot of the code and the results. Note: The query will display all fields (account number, store name, short description, long description, balance, and any others you may have added. If you have more than one table, you will need to JOIN the tables to include columns from each table) using "Cheese & Dairy" to filter the results of the query. Each student is to update the full database with everyone's records. Select all the records in the Chart of Accounts Table and display.  Take a screenshot of the executed code and the results. Update the Team Project Plan with who did each task for this week and submit with the Week Four assignment. Take screenshots of the successfully executed code and copy into a Word document.

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents.

Learning team

Aug 06, 2018 11:59 PM 5

  1. For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

POS 410 Week 4 Individual Assignment SQL Reports

 

Instructions: Create the following queries in preparation for creating reports:   

  • Write one SQL Query to calculate the average Age for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the average Salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the maximum salary for all employees. (Output shows Alias).
  • Write one SQL Query to calculate the minimum salary for all employees. (Output shows Alias).
  • Write one SQL Query to Count all employees and GROUP BY Age and Gender. (Output shows Alias). •  Calculate the number of exempt and non-exempt employees there are, by job code. The results should be sorted in descending order. Take a screenshot of the code and results from each of the bullets above and paste into a Word document. Save all code in a separate Notepad file. Using SQL Server® Data Tools, select one query from the list above and create a report. Join both the Job Title Table and the Employee table in the output and provide subtotals of the Salaries by Job title and a grand total at the end of the report.

Submission of Individual and Learning Team Assignments for each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.   
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

.

WEEK  5

POS 410 Week 5 Learning Team Assignment SQL Accounting Database Report

 

Instructions: Finalize the following Learning Team assignment you have been working on throughout the course. Add the records from the data sheet for Week Four.  Split the records between all team members so each team member is writing a portion of the SQL code for this week.  Each team member is to execute the code for creating the database, the table, and the final result set. Take a screenshot of the code and results from above and paste into a Word document. Save all code in a separate Notepad file. Create the query for the Final Chart of Accounts report to be created in SQL Server® Data Tools. Create a Chart of Accounts report using SQL Server Data Tools Every member of the team will each create the SQL database Chart of Accounts report and then select one to represent the team for submission. (The report will display all fields with a break based on the first two digits of the account number and subtotal of the balance field at each break, and a grand total at the end of the report.) Select one Chart of Accounts report with your team to represent the team's final report. Update the Team Project Plan with who did each task for this week and submit with the Week Five assignment.

Submission of Individual and Learning Team Assignments for each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.    
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

POS 410 Week 5 Individual Assignment Reporting

 

Instructions: Write one SQL Query to calculate the maximum salaries for employees by Job Classification. (Output shows Alias). Write one SQL Query to calculate the minimum salaries for Employees by Job Title. (Output shows Alias). Take a screenshot of the code and results from each of the queries above and paste into a Word document.

Using SQL Server® Data Tools, create a final report of ALL employees with their Job information.  Join both tables for this report.  Provide a subtotal of salaries by Job Classification and a Grand total of all salaries. Save the report in .pdf format.

Submission of Individual and Learning Team Assignments For each assignment, make sure that you provide a single MS Word document that contains the following items:   

  1. A title page including your name. Your name should also be included in the header of the documents. 1.  For Learning Teams, simply include your team name in the header. However, each team member's name should be on the title page.  
  2. All SQL query statements (copy and paste from your query editor). Code is to be manually typed. Due to the large volume of records associated with the Learning Team assignment; the import function may be used.   
  3. Copy and paste the results, or provide a screen shot of the resulting views. (Select *)
  4. Results will include the execution status statement results
  5. A short analysis of the query (at least two complete sentences) stating if the query executed as expected Submit your document to the Assignment Files tab.

 

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question