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

Exercise No. 11: Supply (log)

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

We have four dimensions with the following hierarchical structure:

Table L.E.6.1 - Supply

"Unit price" and "Number of supplies" are the key figures in this example. The following additional attributes have to be considered: the supplier's address "S_su_add", the item's size "I_it_siz" and the employee's date of birth "E_em_dob"

Please draw the Classic Star and the Fact Constellation Schema. Then draw the example's dimension tables normalized!

Solution

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

Exercises List