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

Exercise No. 21: Soccer Goal (dfm)

In the fol­lo­wing E/R sche­ma a play­er scores a goal. The play­er be­longs to a cer­tain soc­cer team and is of a cer­tain na­tio­na­li­ty (par­al­lel hier­ar­chy); the soc­cer team plays in a cer­tain na­tio­nal le­ague and the na­tio­na­li­ty of the play­er tells us about the con­ti­nent the play­er comes from. The goal its­elf is al­lo­wed by a re­fe­ree and is wat­ched by spec­ta­tors. The time di­men­si­on con­sists of month, six-​month and year.

Fi­gu­re D.E.33.1 - soc­cer goal

Plea­se iden­ti­fy the fact of in­te­rest and build the at­tri­bu­te tree. Some at­tri­bu­tes can­not be used for ag­gre­ga­ti­on in a me­a­ning­ful way. Those should be tag­ged as non-​dimension at­tri­bu­tes in the fact sche­ma.

Then de­ri­ve the fact sche­ma from the tree by de­fi­ning di­men­si­ons, fact at­tri­bu­tes and hier­ar­chies and build a glos­sa­ry for the fact at­tri­bu­tes if there are any.

Plea­se in­clu­de an ad­di­tio­nal fact at­tri­bu­te coun­ting the num­ber of goals.

So­lu­ti­on

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

Ex­er­ci­s­es List