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

Exercise No. 23: Travelling (dfm)

In this E/R schema a person - who is classified by type and then by class - travels to a destination. This destination belongs to a certain country which again belongs to a certain continent. This travel is done by a certain mode of transport (car, train, plane, etc.) The time dimension consists of quarter, six-month and year.

Figure D.E.47.1 - Travelling

Please identify the fact of interest and build the attribute tree. Some attributes cannot be used for aggregation in a meaningful way. Those should be tagged as non-dimension attributes in the fact schema.

Then derive the fact schema from the tree by defining dimensions, fact attributes and hierarchies and build a glossary for the fact attributes if there are any.

Please include an additional fact attribute counting the number of persons.

Solution

This exercise is part of a case study: dfm - apa - log

Exercises List