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

Exercise No. 31: Shipments (dfm)

The following simplified E/R-diagram describes the shipment of goods.

Batches belonging to certain groups are shipped to certain destinations in various countries via different modes of transportation. A certain cost center is responsible for each shipment. The time dimension consists of month and year.

Figure D.E.68.1 - Shipments

Let us assume that the attribute costs already includes all tariffs. Further information about the tariffs shall not be transferred into the data warehouse. Analysis will take place at the cost center group level, information about cost centers is not needed.

Please identify the fact of interest and build the attribute tree.

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

Solution

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

Exercises List