Discussion of heather sweeney designs operational database

Assignment Help Database Management System
Reference no: EM13812124

Based on the discussion of the Heather Sweeney Designs operational database (HSD) and dimensional database (HSD-DW) in the text, answer the following questions.

A. Using the SQL statements shown in Figure 1, create the HSD-DW data-base in a DBMS.

B. What transformations of data were made before HSD-DW was loaded with data? List all the transformations, showing the original format of the HSD data and how they appear in the HSD-DW database.

C. Write the complete set of SQL statements necessary to load the transformed data into the HSD-DW database.

D. Populate the HSD-DW database, using the SQL statements you wrote to answer part C.

E. Figure 2 shows the SQL code to create the SALES_FOR_RFM fact table shown in Figure 3. Using those statements, add the SALES_FO&RFM table to your HSD-DW database.

F. What transformations of data are necessary to load the SALES_FOR_RPM table? List any needed transformations, showing the original format of the HSD data and how they appear in the HSD-DW database.

G. What data will be used to load the SALES_FOR_RPM fact table? Write the complete set of SQL statements necessary to load this data.

H. Populate the SALES_FOR_RPM fact table, using the SQL statements you wrote to answer part G.

I. Write an SQL query similar to the one shown on page 420 that uses the total dollar amount of each day's product sales as the measure (instead of the number of products sold each clay).

J. Write the SQL view equivalent of the SQL query you wrote to answer part I.

K. Create the SQL view you wrote to answer part J in your HSD-DW database.

L. Create a Microsoft Excel 2010 workbook named HSD-DW-BI-Exercises.xlsx.

M. Using either the results of your SQL query from part K (copy the results of the query into a worksheet in the HSD.DW.131.xlsx workbook and then format this range as a worksheet table) or your SQL view from part 1. (Create a Microsoft Excel data connection to the view), create an OLAP report similar to the OLAP report shown in Figure. (Hint: If you need help with the needed Microsoft Excel actions, search in the Microsoft Excel help system for more information.)

95_img1.png

1574_img2.png

1532_img3.png

Reference no: EM13812124

Questions Cloud

Stanford county prison experiment : STANFORD COUNTY PRISON EXPERIMENT
Write a summary of the carol simons : Write a summary of the Carol Simons.
Find the energy the person expends pulling the crate : Sketch a free body diagram showing the forces acting on the crate and find the energy the person expends pulling the crate, the amount of energy converted to heat via friction, and the increase in the kinetic energy of the crate.
Write a summary of the yearn hong choi : Write a summary of the Yearn Hong Choi.
Discussion of heather sweeney designs operational database : Based on the discussion of the Heather Sweeney Designs operational database (HSD) and dimensional database (HSD-DW) in the text, answer the following questions. Using the SQL statements shown in Figure 1, create the HSD-DW data-base in a DBMS
Question regarding the process design matrix : Complete the process design matrix. Write an executive summary identifying appropriate design approaches for a selected product and service.
Assignment on violence against women : VIOLENCE AGAINST WOMEN
Write about war between the united states and iran : How do states bargain with each other to get what they want, and what lessons apply to the U.S. and Iran
Write a paper explaining that the type of government : For instance you may write a paper explaining that the type of government selected is a democracy and why, and the opposition would be those that disapprove of democracies and why.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Why data-warehousing greatest threat to individual privacy

Consider following opinion shared by some people: database management systems and data-warehousing techniques are the greatest threat to individual privacy in modern times. What is your opinion?

  Describe how you have represented weak entities

Describe how you have represented weak entities, if any exist and describe how you have represented super type and subtype entities, if any exist.

  Create matrix report showing territory sales totals by year

Create a matrix report showing territory sales totals by year and quarter. Provide an interpretation of the results. The interpretation must be a minimum of one paragraph (3 to 5 well-formed sentences) with no spelling or grammatical errors. Based..

  Discuss how olap and data warehousing technologies

Discuss how OLAP and data warehousing technologies work together in solving user problems. What are the advantages and disadvantages of the different OLAP technologies (MOLAP, ROLAP, HOLAP)?

  Describe the entity-relationship model

Composite and multi-valued attributes can be nested to any number of levels.

  Justification for utalizing database management system

What is the justification for utalizing database management system approach

  Explain what the data entries in each of the following index

Explain what the data entries in each of the following indexes contain. If the order of entries is signi?cant, say so and explain why. If such an index cannot be constructed, say so and explain why

  Database technologies what is lan based database management

what is lan based database management system ltbrgtgive an example of lan based database management system with a

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  Part a - use cases perform a requirements analysis for the

part a - use cases perform a requirements analysis for the case study. express the results using the following

  What is a data model and what is it purpose

What is a data model and what is it purpose and what is a prototype and what is its purpose - What is a use case, and what is its purpose?

  Database application improvements question

Submit an Executive Memo addressed to the CIO and the board of directors. Last week, the CIO reviewed your presentation and has decided to move forward with your recommendations for improvements.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd