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

Exercise No. 13: Writing Tests (log)

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

We have four dimensions with the following hierarchical structure:

Table L.E.25.1 - writing tests

"Mark" is the only key figure in this example. There are no additional attributes.

Please draw the Classic Star and the Fact Constellation Schema. Then draw the example's dimension tables partitioned and normalized and use them to build a Snowflake Schema!

Solution

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

Exercises List