Reference no: EM131382751
Directions
For this assignment, you will group data and resolve query errors via solutions appropriate to each.
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. You will also create a Visio diagram of relationships you used to arrive at your conclusions, but note that one Visio diagram may or may not be required for each individual scenario; some scenarios may use the same Visio diagram as explanation. As such, you will compile and submit all five query scenario solutions into one submission, with the appropriate number of Word documents, Excel spreadsheets, and Visio diagrams as needed.
Your submission will be assessed on:
- Completion of all required elements (i.e., Word document, Excel spreadsheet, and Visio diagram).
- 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
Questions needing answered -
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" table 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 numbers of how many products 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. Compile this task as per the assignment requirements.
Problem Five: Now that you have provided the Sales Manager with YTD sales by market segment in Problem Four, the Sales Manager has one more task to complete all the information required for the sales meeting. The Sales Manager now asks you to provide sales by state year to date. 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.
Difference between a threat and attack
: Discuss the difference between a threat and attack. Describe how a vulnerability may be converted into an attack (provide an example in your explanation)
|
Supporting rss subscription site
: Select a topic of personal interest and post the link (and a screenshot, if possible) to a supporting RSS subscription site. Discuss the pros and cons of subscribing to an RSS feed.
|
How does amount of funds available affect choices on capital
: Write a 500 to 600 word paper in which you explain the objectives of capital investment decisions. In your paper, address the following- How does the amount of funds available affect choices on capital investment decisions?
|
What is the total bit rate available for short messages
: Suppose that five users in the cell or sector have messages addressed to them at the same time. What is the bit rate available for each user?
|
Resolve query errors via solutions appropriate
: 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.
|
How dothe variables or phenomenon addressed in your study
: How dothe variables or phenomenon addressed in your study inform the method, design, research questions, and data collection instrument to be used? What are two instruments that might be used to gather data for your study? Why do you believe these..
|
Which of the given payments would be considered pos
: FIN 369- In the terminology used by BL, which of the following payments would be considered POS? In the terminology used by BL on p. 4, which of the payments in Question 2 would be considered remote commerce?
|
Perception of the hacker changed over recent years
: How has the perception of the hacker changed over recent years? (Lone wolf vs organized hacking groups) What is the profile of a hacker today?
|
What are the various types of malware
: What are the various types of malware? How do worms differ from viruses? Do Trojan horses carry viruses or worms? ( 160 word minimum, give example of atleast one worm and virus and differences)
|