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

Exercise No. 1: Flying Airplane (log)

This case deals with a captain flying an airplane.

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

There is only one key figure in this example ("number of flights"). Each captain has an additional attribute "C_c_dob", the captain's date of birth and each airplane has an additional attribute "A_a_age", the airplane's age.

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