Auto Dealership PINEVIEW FORD is organized as follows: - Dealership keeps track of Vehicle Identification number of every vehicle that is for sale, sold, or serviced by the dealership. - 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 Create a star schema diagram that will enable PINEVIEW FORD to analyze their revenue. The fact table will include: for every instance of revenue generated- the amount generated The star schema will include all dimensions that can be useful for analyzing revenues Submit one word (or .pdf document) with all of the content as listed here 1. star schema of the data warehouse with the core fact table (it is recommended to create it in ERDplus) 2. color coded process of identification which sources map to which element of the star schema (you can open the attached mapping template in Paint and use it) 3. tables (created in Word or Excel) showing the actual data in the dimension table and fact table. 4. add a two way aggregate fact table named: aggregate revenue by customer gender and vehicle make: Add this aggregate fact table additional dimension(s) to the star schema. Also add the corresponding tables with actual data The data sources available are the PINEVIEW FORD operational database and PINEVIEW FORD VEHICLE RENTAL LOG (shown below) SOURCE 1: PINEVIEW FORD ER DIAGRAM and the tables based on it (with data) I SOURCE 2: PINEVIEW VEHICLE RENTAL LOG In addition to selling and servicing vehicles. PINEVIEW FORD occasionally rents vehicles. The following is the vehicle rental log that is being kept in a spreadsheet format: Auto Dealership PINEVIEW FORD is organized as follows: - Dealership keeps track of Vehicle Identification number of every vehicle that is for sale, sold, or serviced by the dealership. - 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 Create a star schema diagram that will enable PINEVIEW FORD to analyze their revenue. The fact table will include: for every instance of revenue generated- the amount generated The star schema will include all dimensions that can be useful for analyzing revenues Submit one word (or .pdf document) with all of the content as listed here 1. star schema of the data warehouse with the core fact table (it is recommended to create it in ERDplus) 2. color coded process of identification which sources map to which element of the star schema (you can open the attached mapping template in Paint and use it) 3. tables (created in Word or Excel) showing the actual data in the dimension table and fact table. 4. add a two way aggregate fact table named: aggregate revenue by customer gender and vehicle make: Add this aggregate fact table additional dimension(s) to the star schema. Also add the corresponding tables with actual data The data sources available are the PINEVIEW FORD operational database and PINEVIEW FORD VEHICLE RENTAL LOG (shown below) SOURCE 1: PINEVIEW FORD ER DIAGRAM and the tables based on it (with data) I SOURCE 2: PINEVIEW VEHICLE RENTAL LOG In addition to selling and servicing vehicles. PINEVIEW FORD occasionally rents vehicles. The following is the vehicle rental log that is being kept in a spreadsheet format
