MC9 City Boomers City Boomers wants to create an analytical database to analyze its sales revenue....

 

Transcribed Image Text:

MC9 City Boomers City Boomers wants to create an analytical database to analyze its sales revenue. The only available data source is the City Boomers Revenue Database (depicted by the ER diagram in Figure 2.63 in mini case MC9 in Chapter 2, STID SPID Involves 100 SALES TRANSACTION SALESPERSON MID SPName Payment Method Includes MERCHANDISE MType GameID OccursDuring MPrice NoOfTickets Sold Quantity TicketID GameDate Price GAME SeatType SoldFor TICKET Opponent Payment Method PromotesAt FeeCharged Sells Company ID AID Company Name ADVERTISER CompetesWith AName AGENT and the relational schema created in mini case MC9 in Chapter 3). Create a dimensional model for a data warehouse that enables analysis of sales revenue by: date item sold (merchandise or ticket) employee (salesperson or agent) game Each row in the fact table will represent the monetary amount of revenue taken in during a merchandise purchase or ticket sale. MC9 City Boomers City Boomers wants to create an analytical database to analyze its sales revenue. The only available data source is the City Boomers Revenue Database (depicted by the ER diagram in Figure 2.63 in mini case MC9 in Chapter 2, STID SPID Involves 100 SALES TRANSACTION SALESPERSON MID SPName Payment Method Includes MERCHANDISE MType GameID OccursDuring MPrice NoOfTickets Sold Quantity TicketID GameDate Price GAME SeatType SoldFor TICKET Opponent Payment Method PromotesAt FeeCharged Sells Company ID AID Company Name ADVERTISER CompetesWith AName AGENT and the relational schema created in mini case MC9 in Chapter 3). Create a dimensional model for a data warehouse that enables analysis of sales revenue by: date item sold (merchandise or ticket) employee (salesperson or agent) game Each row in the fact table will represent the monetary amount of revenue taken in during a merchandise purchase or ticket sale.