please explain using detailed digrams

90 - PART 2/ Analytical Databases Figure 8.46 Source 2: Pineview Rental Log The data warehouse has to enable an analysis of revenue by all relevant dimensions. (Hint, the dimensions should enable analysis by dates, vehicles, employees, clients, and types of revenue.) 3.4a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Pineview Ford. .4b Using data from Figures 8.45 and 8.46 , illustrate how the tables in the dimensional model created in E8.4a would be populated. 290 - PART 2/Analytical Databases Figure 8.46 Source 2: Pineview Rental Log Figure - Vehicles are sold via a sale transaction. One transaction involves one sales person, one client, and one vehicle. - Vehicles are serviced via a service transaction. One transaction involves one service person, one client, and one vehicle. - In addition to selling and servicing vehicles, Pineview Ford occasionally rents vehicles. One rental transaction involves one rental agent, one client, and one vehicle. Pineview Ford wants to create the analytical database (data warehouse) to analyze their revenue. The two available data sources, Source 1 and Source 2, are described below. Source 1 Pineview Sales and Service Database, shown in Figure 8.45 . Source 2 Pineview Rental Log, shown in Figure 8.46. The data warehouse has to enable an analysis of revenue by all relevant dimensions. (Hint, the dimensions should enable analysis by dates, vehicles, employees, clients, and types of revenue.) E8.4a Based on the sources and requirements listed above, create a dimensional model that will be used for the dimensionally modeled data warehouse for Pineview Ford. E8.4b Using data from Figures 8.45 and 8.46 , illustrate how the tables in the dimensional model created in E8.4a would be populated