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

Exercise No. 20: Freight Bookings (log)

We will now build a logical model for the "freight bookings" case.

We have four dimensions with the following hierarchical structure:

Table L.E.28.1 - freight bookings

"Costs" is the only key figure in this example. Each customer has an additional attribute "C_cu_add", the customer's address, each branch of a forwarding agent has an additional attribute "E_bf_add", the branch's address and each freight has an additional attribute "F_fr_des", the freight's description.

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

Solution

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

Exercises List