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

Exercise No. 6: Warehouse (log)

This case deals with inventory monitoring in a warehouse.

We have three dimensions with the following hierarchical structure:

Table L.E.17.1 - A warehouse

The single key figure in this example is the "inventory level".

Please draw the Classic Star Schema for this example, create the dimension table "product", then build the Fact Constellation Schema.

Then you should draw this example's dimension tables partitioned and normalized.

Solution

Exercises List