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

Exercise No. 16: Workout (log)

This cube stores data about athletes doing workouts.

We have four dimensions with the following hierarchical structure:

Table L.E.55.1 - workout

"Number of workouts" is the only key figure. Each athlete has an attribute A_at_dob, the date of birth, and each personal coach has his address ("P_pc_ad") as an additional attribute.

Please draw the Classic Star and the Fact Constellation Schema. Then draw 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