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

Exercise No. 14: Bus Maintenance (log)

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

We have four dimensions with the following hierarchical structure:

Table L.E.28.1 - bus maintenance

"Costs" and "no. of services" are the key figures in this example. Each bus has an additional attribute "B_bu_age", the age of the bus and each driver has an additional attribute "D_dr_exp", the driver's experience.

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

Solution

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

Exercises List