1) Create a dimensional model containing an aggregated fact table, where a fact table shows a summary of daily revenue amount for each officer. Use ERDPlus to create your model.
2) Populate the tables created in part d) with the data. Use the data that you used to populate the tables in the Figure 8.46 as a basis for aggregation.

 

  

 

Problem #1 (60%) ES: Consider the following scenario intvolring the City Police Department The City Police Department wants to create an analytical danabane to analyze its ticket reseme. The two arailable data sourcen, Source ! and Source 2, are described below. Source 1 The City Police Depertment maintains the Ticketed Violations Database, shoNm in Eiguze 8.43 Source 2 The Department ofMotor Vehicles (DAV) maintains the Vehicle Registation Teble, shown in Eague 44. The daa warehouse han to emable an analynis ef ticket evemes by: date, including full date day of week day of month month * quarter officer, including * officer ID *officer name officer rank payer of the ticket, including