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

Exercise No. 24: Paperboy (log)

We now build a logical model for the "paperboy" case.

We have four dimensions with the following hierarchical structure:

Table L.E.50.1 - paperboy

There is only one key figure in this example, "time of delivery". Each customer has an additional attribute "C_cu_add", the address of a customer.

Please draw the Classic Star and the Fact Constellation Schema. Then draw the example's dimension tables normalized!

Solution

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

Exercises List