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

Exercise No. 38: Advertising Campaign (dfm)

This E/R-schema is about an advertising campaign for a product.

A company is in need of an advertising camapign for a product - the product can belong to a product group. Therefore an advertising agency is hired to carry out an advertising campaign in countries which belong to a continent. The time dimension consists of month, quarter and year.

Figure D.E.24.1 - Advertising Campaign

Please identify the fact of interest and build the attribute tree. No attributes have to be pruned or grafted. Some attributes cannot be used for aggregation in a meaningful way. Those should be tagged as non-dimension attributes in the fact schema.

Then derive the fact schema from the tree by defining dimensions, fact attributes and hierarchies and build a glossary for the fact attributes.

Please include an additional fact attribute, the duration of the advertising campaign which may be aggregated using the "average" operator along all dimensions.

Solution

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

Exercises List