Reference no: EM131626654
Question: For each query scenario in this assignment, compose a Word document that provides and explains the SQL code you have written accompanied by an Excel spreadsheet presenting the associated data. As such, you will compile and submit all three query scenario solutions into one submission, with the appropriate number of Word documents, Excel spreadsheets as needed.
Directions
Your submission will be assessed on:
- Completion of all required elements (i.e., Word document, Excel spreadsheet).
- The success of each query (i.e., how well the query works and performs as intended).
- Thoroughness of the information and data provided.
Query Scenarios
Problem One
As part of a yearly fundraising effort for the community, your manager has given you an Excel worksheet with everyone's pledged donations titled "Donations." The sheet consists of three tabs that correspond to the three months employees were asked to submit pledges. Load this file into the AdventureWorks database through the import and export wizard. Once loaded use a UNION ALL statement to combine the three data sets into a temporary table called "#TotalDonations." Compile this task as per the assignment requirements.
Problem Two
Redoing the UNION ALL statement you created in Problem One, a temporary table should be created, looking exclusively at SUM of Donations by Month. Title each of the three fields "Donations and Month" with the temporary table titled "#DonationsbyMonth." When complete, provide also the total of the final amount of donations raised. Compile this task as per the assignment requirements.
Problem Three
Your manager e-mails you about the final results you provided in Problem Three, and believes you must have made a mistake when calculating the total donations. The amount is $100 shy of the total amount by the manager's calculations. The manager thinks it is possible that one employee might have accidently pledged $100 twice. Explain how this event might occur with a UNION ALL and, if so, rewrite the first query with a UNION statement. Is your manager's assumption correct?
General Requirements
Compile the Word, Excel documents into one document to submit
|
Java process and processbuilder components
: Research Java's Process and ProcessBuilder components and the model Java uses for interaction with other Processes under the Operating System.
|
|
Describe construction companies in the community
: Richard is an employee of the Dun Construction Corp. While delivering materials to a construction site, he carelessly backs Dun's truck into a passenger vehicle
|
|
Describes four different ob models of managers and leaders
: Describes four different OB models of managers and leaders: the Autocratic Model, the Custodial Model, the Collegial Model, and the Supportive Model.
|
|
Meet the assignment requirements
: If one site does not have that many issues you can identify, then please select a second page in order to meet the assignment requirements.
|
|
Completion of all required elements
: Completion of all required elements (i.e., Word document, Excel spreadsheet). The success of each query (i.e., how well the query works and performs as intended
|
|
Discuss the caplans leave on vacation
: The Caplans leave on vacation, and during their absence Faithful is unable to buy and install Crane plumbing ?xtures
|
|
Discuss the components and the history of the new realities
: Discuss the components and the history of these new realities in our world and how our lives have been affected by these new realities.
|
|
What is the cpu utilization
: What is the CPU utilization if there are 5 processes running at the same time, and on average the CPU spends 30% of its time waiting on I/O completion?
|
|
Discuss the purchase money was to be paid and possession
: Reginald decided he no longer wanted to keep the holiday house he owns at Lorne on Victoria's south-west coast
|