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

Exercise No. 21: Soccer Goal (log)

This case is about scoring soccer goals.

We have four dimensions with the following hierarchical structure (the dimension "Player" features a parallel hierarchy at level 1):

Table L.E.33.1 - soccer goal

There is only one key figure in this example, "no. of goals". Each player has an additional attribute "P_pl_dob", the player's date of birth.

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