a. Using the data in Figure 8.41, illustrate how the tables in the dimensional model shown in Figure 8.42 would be populated.

b. Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of units sold and dollars sold for daily purchases of each product in each store.

c. Populate the tables created in E8.1b with the data. Use the data that you used to populate the tables shown in Figure 8.42 as the basis for aggregation.