Tag Archives: City Boomers

Briefly explain what happen to each row in fact tables connected to the item of Item value “Merchandise”, and the Item value “Ticket”.

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 […]