E$8\mathrm{.}2$b Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of the daily revenue amount for each officer. $(8$ points$)$

E$8\mathrm{.}2$c Populate the tables created in E$8\mathrm{.}2$b with the data. Use the data that you used to populate the tables in Figure $8\mathrm{.}42$ as a basis for aggregation. $(8$ points$)$