Can someone answer the question at the top and explain how they got the answer please?

MC6 Jones Dozers Jones Dozers wants to create an analytical database to analyze its sales and rentals revenue. The only available data source is the Jones Dozers Sales and Rentals Database (depicted by the ER diagram in Figure 2.59 in mini case MC6 in Chapter 2, and the relational schema created in mini case MC6 in Chapter 3). 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 sales rep Each row in the fact table will represent the monetary amount of revenue taken in during one sale or rental transaction. LastInspectDate Date SerialNo DateMade Price RentTransID EQUIPMENT Rented Via RENTAL SReplName SRepFName Conducts Cup (SRepName) CustID SRepID Rents Via Sold Via Rank CustName Has CUSTOMER SALES REP EquipDetailID CustCategory E x 30,1) Buys Via (0,3) (0,1) Conducts Protege Mentor EQUIPMENT DETAIL Sale TransID Mentors Make Model SALE Type Price Date FIGURE 2.59 ER diagram for the Jones Dozers Sales and Rentals Database. EquipDetailid Make Type Model RentTransID Price Date CustID (FK) SerialNo (FK) SReplD (FK) SerialNo LastInspectDate DateMade Equip Details (FK) CustID CustName CustCategory SReplD SRepLName SRepFName Rank MentoredBy (O)(FK) Sale TransID Price Date SerialNo (FK) CustID (FK) SReplD (FK) MC6 Jones Dozers Jones Dozers wants to create an analytical database to analyze its sales and rentals revenue. The only available data source is the Jones Dozers Sales and Rentals Database (depicted by the ER diagram in Figure 2.59 in mini case MC6 in Chapter 2, and the relational schema created in mini case MC6 in Chapter 3). 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 sales rep Each row in the fact table will represent the monetary amount of revenue taken in during one sale or rental transaction. LastInspectDate Date SerialNo DateMade Price RentTransID EQUIPMENT Rented Via RENTAL SReplName SRepFName Conducts Cup (SRepName) CustID SRepID Rents Via Sold Via Rank CustName Has CUSTOMER SALES REP EquipDetailID CustCategory E x 30,1) Buys Via (0,3) (0,1) Conducts Protege Mentor EQUIPMENT DETAIL Sale TransID Mentors Make Model SALE Type Price Date FIGURE 2.59 ER diagram for the Jones Dozers Sales and Rentals Database. EquipDetailid Make Type Model RentTransID Price Date CustID (FK) SerialNo (FK) SReplD (FK) SerialNo LastInspectDate DateMade Equip Details (FK) CustID CustName CustCategory SReplD SRepLName SRepFName Rank MentoredBy (O)(FK) Sale TransID Price Date SerialNo (FK) CustID (FK) SReplD (FK)