1. 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 12-13, create the HSD_DW database in a DBMS.
B. What possible transformations of data were made before HSD_DW was loaded with data? List some possible 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 12-35 shows the SQL code to create the SALES_FOR_RFM fact table shown in Figure 12-18. Using those statements, add the SALES_FOR_RFM table to your HSD_DW database.
F. What possible transformations of data are necessary to load the SALES_FOR_ RFM table? List some possible transformations, showing the original format of the HSD data and how they appear in the HSD_DW database.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here