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

Exercise No. 44: Tri-County Hospital (log)

This cube stores data about patients treated in the Tri-County Hospital.

We have four dimensions with the following hierarchical structure (the dimension "patient" features a parallel hierarchy at level 1):

Table L.E.58.1 - Tri-County Hospital

There is only one key figure in this example, costs (of the treatment). All additional attributes have been grafted.

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

Solution

Exercises List