MIS 610 Topic 2 CASE Query Errors

The purpose of this assignment is to evaluate and resolve query errors.

For this assignment, you will group data and resolve query errors via solutions appropriate to each. 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

Your manager needs you to compile a list of all the products the company sells as well as the time required to manufacture them in order to provide this information to the sales department for the presentation of timelines in an upcoming company-wide sales meeting. Your manager specifically needs to know which products take (1) less than 4 days to manufacture, or (2) more than 4 days to manufacture. Looking at the “Production. Product” and using CASE logic, identify each product with a tag of “Under 4 days” or “More than 4 days” and title the field “Timeframe.”

Problem Two

Using the query you created from Problem One as a basis, your manager wants to know the number of products that fall into each of the two categories.

Note: This process requires two separate SUM statements using CASE logic through the “Manufacturing time.”

Problem Three

Also related to the upcoming sales meeting, the sales manager is building a report for which a list of states using a custom market name is required. Using the “Person.StateProvince” table, use CASE logic to turn “TerritoryID” into a named market for each of the following: Western Market, North Eastern Market, Mid-Western Market, South-Western Market, and South-Eastern Market. Make sure to include the “TerritoryID” and to order your results by this field.

Problem Four

The sales manager has also identified a need to know “Year to Date” sales by the new market segments using the same descriptions you developed in Problem Three.

Problem Five

Now that you have provided the sales manager with year-to-date sales by market segment in Problem Four, the sales manager would like you to provide year-to-date sales by state. This is not realistically possible through the existing company database setup. Explain why and what would be needed for the database to accomplish this dataset in the future.

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 it 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.

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our Guarantees

Money-back Guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism Guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision Policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy Policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation Guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more