MC$8$ Jones Dozers

Jones Dozers want to create an analytical database to analyze its sales and rentals revenus. The only available data source is the Jones Dozers Sales and Rentals Database $($depicted by the ER diagram below$).$

Create a dimensional model for a data warehouse that enables analysis of sales and rentals revenue by:

Date, type of revenue $($sale or rental$),$ customer, equipment, and sales rep.

Each row in the fact table will represent the monetary amount of revenue taken in during a merchandise purchase or ticket sale.