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

Exercise No. 48: Lecture at the MIT (log)

This case is about lectures at the MIT.

Lectures at the MIT are hold by a lecturer. This person can be an assistant or a professor (parallel hierarchy). Students attend a lecture. A lecture has a certain subject which belongs to a certain subject group and takes place in a certain lecture hall. This hall is part of a university building. The time dimension consists of day and week.

We have five dimensions with the following hierarchical structure (the dimension "Lecturer" features a parallel hierarchy at level 1):

Table L.E.32.1 - lectures at the MIT

There is only one key figure "number of lectures" in this example. Each subject has an additional attribute "SU_su_des", the description of the project.

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

Solution

Exercises List