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

Exercise No. 55: Opera by Wolfgang Amadeus Mozart (log)

This case deals with opera-singers and musicians performing in an opera by Wolfgang Amadeus Mozart.

The opera-singer sings in a certain register and belongs to the cast. The musician plays a certain instrument which belongs to an instrument group. This group is part of an orchestra. The opera is written by a certain composer. The performance is watched by a spectator and by a critic. The time dimension consists of day and week.

We have six dimensions with the following hierarchical structure:

Table L.E.37.1 - opera

There is only one key figure in this example "no. of performances". Each opera has an additional attribute "O_op_tit", the opera's title.

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

Exercises List