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

Exercise No. 38: Advertising Campaign (log)

We will now build a logical model for the "advertising campaign" case.

We have five dimensions with the following hierarchical structure:

Table L.E.24.1 - advertising campaign

"Costs" and "duration" are the key figures in this example. Each product has an additional attribute "P_pr_des", the product's description; and each country has an additional attribute "C_co_cbh", the country's customer behaviour.

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

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

Exercises List