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 8-10, 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 8-22 shows the SQL code to create the SALES FOR RFM fact table shown in Figure 8-15. Using those statements, add the SALES_FOR_RFM table to your HSD-DW database.

AppendixLO1