MIS 610 Topic 1 Query Building GCU

MIS 610 Topic 1 Query Building GCU

MIS 610 Topic 1 Query Building GCU


In stock


  • Description
  • Reviews (0)


MIS 610 Topic 1 Query Building GCU

The purpose of this assignment is to demonstrate query building skills.

For this assignment, you will construct queries using both static and dynamic word problems for each of five scenarios. You will use Microsoft SQL Server 2016 Developer Edition and the content from the AdventureWorks 2016 and Scripts for SQL Server 2016 CTP3 to complete the assignment.

Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to Excel for a visual check of accuracy.

Create a Word document that includes the SQL queries used to explore the database tables, and answer the following questions.

Query Scenarios

Problem One

In your new job, you realize you will be calling up the “HumanResources.Employee” table on a frequent basis to answer questions from your manager. Using what you have learned thus far about stored procedures, create an executable “Employees” dataset that will allow you to quickly reference all records in that dataset. However, note that a stored procedure cannot be used in a SELECT statement after it has been created; it simply allows for a quick command to call up a preset data query you have made.

Problem Two

While a stored procedure is an effective method to review a static dataset, you realize the requirements for questions posed to you change frequently. Your manager often will request information specific to a given job title. You realize you need to create a function that allows a variable to be changed in your SELECT statement each time you run it.

Note: To develop the answer to this problem, set the variable to “Design Engineer” and call the Function @JobTitle.

Problem Three

Your manager wants to build an “Employee Time Off” calendar for the year for easy reference and has asked that you compile a list of vacation hours for each employee under his supervision. This task relates to the one you completed in Problem Two of this assignment, but will require that you restructure the code you developed from Problem Two to build a more complex query in or order to complete the task successfully. As with Problem Two, your manager will request this information often, and on an ongoing basis throughout the year. You realize you need to create a function that allows a variable to be changed in your query statement each time you run it so that you do not need to write new code for every request.

The fields you need to bring in are “First and Last Name” and “Sick and Vacation Hours.”

Note: To develop the answer to this problem, create a join from the person table First and Last Name.

Problem Four

Your manager would like you to classify employee work areas in the building using a color coding system that he developed. Since no such system exists in the company database, he has asked you to upload his personal Excel worksheet into the database as a new table. Using SQL Server Import and Export Wizard, load the “Roster” tab from the Excel file titled “Color Coding.” Write a SELECT statement once loaded to confirm that it loaded correctly.

Problem Five

Now that your color coding system is in place, your manager wants to know which employees  sit in the “Brown” section, as he will be relocating their desks in the future when the department is expanded. To provide him with this information, use the color coding system you developed for Problem Four, making sure to include the “Color Code,” “Job Title,” and concatenate “Last Name” “First Name” separated by a comma, calling the field “Full Name.”

General Requirements

Compile the Excel data file and Word document containing the SQL queries and answers to the questions into a .zip file and submit to your instructor.

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are not required to submit this assignment to LopesWrite.



Course Tutor helps in providing the best essay writing service. If you need 100% original papers for MIS 610 Topic 1 Query Building GCU, then contact us through call or live chat.

MIS 610 Topic 1 Query Building GCU

Best MIS 610 Topic 1 Query Building GCU

MIS 610 Topic 1 Query Building GCU

ACCT 553 DeVryBIAM 500 DeVryCIS 500 STRCIS 558 STRENG 105 GCUFIN 390 DeVryFIN 504 GCUHCA 545 GCUHCA 699 GCUHLT 306 GCUHLT 362 GCUHLT 555 GCUHLT 610 GCUHLT 665 GCUHOSP 594 DeVryHRM 600 DeVryMAT 144 GCUMGMT 600MGT 599 STRMGT 655 GCUMKT 373 GCUPSY 362 GCUPSY 565 GCUPSY 575 GCUPSY 665 GCUSOC 102 GCUSOC 320 GCUSOC 372 GCUSOC 412 GCUNSG 6440 SUHIM 515 GCUNSG 4029 SUHIM 615 GCUNSG 3029 SUNSG 4055 SUNSG 6630 SUNSG 6005 SUCRMJ 310PSY 510 GCUCRMJ 300 DevryCRMJ 425SPD 200 GCU, HLT 490 GCU ,ECH 340 GCU , ECH 440 GCU , ECH 355 GCU ,ECH 350 GCU ,LDR 461 GCU ,ECH 425 GCU ,REL 212 STR ,SCI 115 STR ,CIS 505 STR ,JUS 652 GCUMGT 640 GCUCIS 527 STRSOC 436 GCU,ACC 502 GCUFIN 504 GCU ,MATH 260 DeVry ,ETHC 445 DeVry ,ECET 220 DeVry , CARD 405 DeVryNETW 203 DeVryNETW 205 DeVryECET 365 DeVry ,MATH 270 DeVry ,PHYS 310 DeVry, BIB 106 GCU ,CIS 512 STR ,SYM 506 GCU ,ECN 601 GCU  ,BIAM 570 DeVryPSY 402 GCU , SOC 480 GCU , HUM 112 STR , PHI 210 STR,  ACC 667 GCU,  ACC 622 GCU,  ACC 623 GCU,  ENTR 510 DeVryDNP 840 GCU , BIO 550 GCU , HRM 420 DeVry , ACC 690 GCU  , HCA 807 GCU , ACC 650 GCU , REET 420 DeVry , MIS 605 GCU , ECET 350 DeVry , ENTR 530 DeVry , PSY 102 GCU , MIS 600 GCU , TCH 539 GCU , SPD 300 GCU , HCA 812 GCU , TCH 520 GCU , MGT 410 GCU , MIS 610 GCU




There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

× How can I help you?