Studierende stehen vor dem LC und blicken lächelnd einer Kollegin mit einer Mappe in der Hand nach.

Exercise No. 42: Betting (log)

This cube stores data about customers placing bets in betting office.

We have five dimensions with the following hierarchical structure:

Table L.E.52.1 - betting

"Amount" is the only key figure. Each customer has an additional attribute "C_cu_addr", the address. Each event has an additional attribute "E_ev_odds", the odds for the event.

Please draw the Classic Star Schema and create the dimension table "event". Then draw the Fact Constellation Schema, the dimension tables partitioned and normalized and use them to build a Snowflake Schema!

Solution

This exercise is part of a case study: dfm - apa - log

Exercises List