ASSIGNMENT

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, 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 (mechanism or ticket)
• employee (sales person or agent)
• gameEach row in the fact table will represent the monetary amount of revenue taken in during a merchandise purchase or ticket sale.

In addition, You must briefly explain what happen to each row in fact tables connected to the item of Item value “Merchandise”, and the Item value “Ticket”.