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

Exercise No. 25: Cab Ride (log)

This cube stores data about people riding in a cab.

We have four dimensions with the following hierarchical structure:

Table L.E.51.1 - cab ride

"Km", "price" and "has luggage" are key figures.

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

Solution

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

Exercises List