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

Exercise No. 7: Car Sales (dfm)

The following E/R schema is about selling cars. A car dealer who belongs to a car dealer association sells cars in a certain sales area which belongs to a certain city. The cars are imported by an exclusive importer and are of a certain type. The time dimension consists of week, month and quarter.

Figure D.E.23.1 - car sale

Please identify the fact of interest and build the attribute tree. The car dealer association and the exclusive importer are not of interest for this case. .

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

Please include an additional fact attribute "revenue".

Solution

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

Exercises List