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

Exercise No. 23: Travelling (log)

We will now build a logical model for the "Travelling" case.

We have four dimensions with the following hierarchical structure:

Table L.E.47.1 - Travelling

There are two key figures in this example, "expenses" and "number of persons". Each person has an additional attribute "P_pe_add", the person's address, each type has an additional attribute "P_ty_des", the description of a type and each class has an additional attribute "P_cl_des", the description of a class.

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