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

Exercise No. 40: Compact Disc (log)

In the following exercise a customer asks a store assistant for a compact disc via different modes of communication (phone, face to face, email, etc.). The compact disc is of a certain type and is released by a certain artist (parallel hierarchy). The artist belongs to a certain music company. The time dimension consists of day, week and month.

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

Table L.E.35.1 - compact disc

There are two key figures in this example, "solved" and "no. of inquiries". Each compact disc has an additional attribute "C_cd_tit", the title of the compact disc.

Please draw the Classic Star, create the dimension table "compact disc" and draw the Fact Constellation Schema. Then draw the example's dimension tables normalized and use them to build a Snowflake Schema!

Solution

Exercises List