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

Exercise No. 26: Project Management (dfm)

This simplified E/R schema shows a project managemant case.

The project for a customer is split up to various work packages and always one person is responsible for the completion of the task. It is taken care of in a certain location.
The time dimension consists of day, month and year.

Figure D.E.53.1 - project management

Please identify the fact of interest and build the attribute tree. Attributes that cannot be used for aggregation in a meaningful way 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 if there are any.

Please include an additional fact attribute counting the number of work packages.

Solution

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

Exercises List