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

Exercise No. 1: Flying Airplane (dfm)

This simplified E/R schema shows a captain flying an airplane.

Each airplane belongs to a certain airplane type and to a certain airline (parallel hierarchy). The time dimension consists of day, week and quarter.

Please identify the fact of interest and build the attribute tree. No attributes have to be pruned or grafted, but some of them 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 flights.

Solution

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

Exercises List