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

Exercise No. 2: Banking (dfm)

The following E/R schema shows customers asking for a loan at a bank. The time dimension consists of week, month and year.

 

Figure D.E.2.1 - banking

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 loans.

Solution

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

Exercises List