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

Exercise No. 52: At The Movies (log)

We now build a logical model for the "at the movies" case.

We have five dimensions with the following hierarchical structure:

Table L.E.49.1 - at the movies

There is only one key figure in this example, "number of customers". Each customer group has an additional attribute "C_gr_des", the description of a customer group, each movie-hall type has an additional attribute "MH_ty_des", the description of a movie-hall type and each movie has an additional attribute "M_mo_tit", the title of a movie.

Please draw the Classic Star Schema, create the dimension table "movie" 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