Consider the following scenario involving the City Police Department. The City Police Department wants to create an analytical database to analyze its ticket revenue. The two available data sources, Source 1 and Source 2, are described below .Source 1: The City Police Department maintains the Ticketed Violations Database, shown in Figure 1 Source 2: The Department of Motor Vehicles (DMV) maintains the Vehicle Registration Table, shown in Figure 2 The data warehouse has to enable an analysis of ticket revenues by: date, including: o full date o day of week o day of month o month o quarter o year officer, including: o officer ID o officer name o officer rank . payer of the ticket, including: o payer DLN o payer name o payer gender o payer birth year . vehicle, including: o vehicle LPN o vehicle make o vehicle model o vehicle year Consider the following scenario involving the City Police Department. The City Police Department wants to create an analytical database to analyze its ticket revenue. The two available data sources, Source 1 and Source 2, are described below .Source 1: The City Police Department maintains the Ticketed Violations Database, shown in Figure 1 Source 2: The Department of Motor Vehicles (DMV) maintains the Vehicle Registration Table, shown in Figure 2 The data warehouse has to enable an analysis of ticket revenues by: date, including: o full date o day of week o day of month o month o quarter o year officer, including: o officer ID o officer name o officer rank . payer of the ticket, including: o payer DLN o payer name o payer gender o payer birth year . vehicle, including: o vehicle LPN o vehicle make o vehicle model o vehicle year