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

Exercise No. 32: Haircut (log)

This cube stores data of an information system of a hair dressing salon.

We have four dimensions with the following hierarchical structure (the dimension "stylist" features a parallel hierarchy at level 1):

Table L.E.69.1 - haircut

"Price" is the only key figure. Each customer has an additional attribute "C_cu_dob", the date of birth and each branch has an additional attribute "S_br_addr", the address.

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

Solution

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

Exercises List