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

Exercise No. 57: E-Commerce (log)

We now build a logical model for the "e-commerce" case.

We have six dimensions with the following hierarchical structure:

Table L.E.48.1 - e-commerce

There are two key figures in this example, "sum" and "number of products". Each product has an additional attribute "P_pr_des", the description of a product.

Please draw the Classic Star and the Fact Constellation Schema. Then draw the example's dimension tables partitioned!

Solution

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

Exercises List