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 peop­le ri­ding in a cab.

We have four di­men­si­ons with the fol­lo­wing hier­ar­chi­cal struc­tu­re:

Table L.E.51.1 - cab ride

"Km", "price" and "has lug­ga­ge" are key fi­gu­res.

Plea­se draw the Clas­sic Star and the Fact Con­stel­la­ti­on Sche­ma. Then draw the di­men­si­on ta­bles par­ti­tio­ned and nor­ma­li­zed!

This ex­er­ci­se is part of a case study: dfm - apa - log