a. Using the source data from Figures 8.43 and 8.44, illustrate how the empty tables in Figure 8.46 would be populated.
b. Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of daily revenue amount for each officer.
c. Populate the tables created in E8.2b with the data. Use the data that you used to populate the tables in the Figure 8.46 as a basis for aggregation.