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

Exercise No. 42: Betting (dfm)

This sim­pli­fied E/R sche­ma shows an in­for­ma­ti­on sys­tem of a bet­ting of­fice.

A cus­to­mer places a bet on a cer­tain event using va­rious modes of com­mu­ni­ca­ti­on (in­ter­net, phone, etc.) with a com­pa­ny that has a num­ber of bran­ches in dif­fe­rent ci­ties.
The time di­men­si­on con­sists of day, month and year.

Fi­gu­re D.E.52.1 - bet­ting

Plea­se iden­ti­fy the fact of in­te­rest and build the at­tri­bu­te tree. The at­tri­bu­te type of cus­to­mer has to be pru­ned as this in­for­ma­ti­on is not nee­ded in the data ware­house. At­tri­bu­tes that can­not be used for ag­gre­ga­ti­on in a me­a­ning­ful way 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.

So­lu­ti­on

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

Ex­er­ci­s­es List