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

Exercise No. 15: Restaurant Order (log)

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

We have four dimensions with the following hierarchical structure:

Table L.E.41.1 - restaurant order

There are two key figures in this example, "sum" and "no. of customers". Each meal has an additional attribute "M_me_des", the description of the meal

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

Solution

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

Exercises List