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

Exercise No. 30: Miami University Enrollment (log)

This cube stores data about the Miami University information system.

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

Table L.E.61.1 - Miami University Enrollment

"Number of enrollments" is the only key figure in this exercise. Include the following attributes:

  • each course has an additional attribute "C_co_descr", the description of the course

  • each dorm has an additional attribute "S_do_addr", the address of the dorm

  • each professor has an additional attribute "P_pr_res", the research area of the professor

Please draw the Classic Star and the Fact Constellation Schema. Then draw the dimension tables partitioned and normalized!

Solution

Exercises List