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

Exercise No. 41: Getting Mails at Home (log)

This exercise is about getting mails at home.

A user who is of a certain type gets a mail. The mail is delivered by an Internet Service Provider (ISP) and may be encrypted by a certain encryption standard. The mail itself is of a certain type and belongs to a certain group (parallel hierarchy). The time dimension consists of month and quarter.

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

Table L.E.44.1 - getting mails

There are two key figures in this example, number of gets and number of users. Each mail has an additional attribute "M_ma_siz", the size of the mail and each mail group has an additional attribute "G_gr_des", the description of the group.

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