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

Exercise No. 7: Car Sales (log)

We will now build a logical model for the "car sale" case.

We have three dimensions with the following hierarchical structure:

Table L.E.23.1 - car sale

"Price", "quantity" and "revenue" are the key figures in this example. There are no additional attributes.

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!

Solution

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

Exercises List