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

Exercise No. 10: Cost Center (log)

Continuing APA case "Cost Center" we will now build the logical model.

We have four dimensions with the following hierarchical structure:

Table L.E.4.1 - Cost center

"Costs" is the only key figure in this example. Each building project has an additional attribute "B_bp_des", the project's description, each employee has an additional attribute "E_em_dob", the employee's date of birth and each cost accounting staff has an additional attribute "C_st_dob", the staff's date of birth.

Please draw the Classic Star Schema!

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