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

Exercise No. 8: Toll Road (log)

This cube stores data about vehicles driving on a toll road.

We have three dimensions with the following hierarchical structure:

Table L.E.54.1 - toll road

"Km", "Toll" and "Number of vehicles" are key figures. Each vehicle has an additional attribute "V_ve_owner", the vehicle's owner.

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

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