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 soc­cer goals.

We have four di­men­si­ons with the fol­lo­wing hier­ar­chi­cal struc­tu­re (the di­men­si­on "Play­er" fea­tures a par­al­lel hier­ar­chy at level 1):

Table L.E.33.1 - soc­cer goal

There is only one key fi­gu­re in this examp­le, "no. of goals". Each play­er has an ad­di­tio­nal at­tri­bu­te "P_pl_d­ob", the play­er's date of birth.

Plea­se draw the Clas­sic Star and the Fact Con­stel­la­ti­on Sche­ma. Then draw the examp­le's di­men­si­on ta­bles par­ti­tio­ned and nor­ma­li­zed and use them to build a Snowfla­ke Sche­ma!

So­lu­ti­on

This ex­er­ci­se is part of a case study: dfm - apa - log

Ex­er­ci­s­es List