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

Exercise No. 56: An Accident (log)

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

We have six dimensions with the following hierarchical structure:

Table L.E.45.1 - an accident

There is only one key figure in this example, "fault". Each witness has an additional attribute "W_wi_add", the witness's address and each accident has an additional attribute "A_ac_des", the description of an accident.

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!

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