Databases
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)
game
Each row in the fact table will represent the monetary amount of revenue taken in during a merchandise purchase or ticket sale.
In addition, briefly explain what happen to each row in fact tables connected to the item of Item value “Merchandise”, and the Item value “Ticket”.
Briefly explain what happen to each row in fact tables connected to the item of Item value “Merchandise”, and the Item value “Ticket”.
