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

Exercise No. 2: Banking (log)

This case deals with a customer asking for a loan at a bank.

We have three dimensions with the following hierarchical structure:

Table L.E.2.1 - customer asks for a loan

"Costs/fee" and "Number of loans" are the key figures in this example. Each customer has an additional attribute "C_cu_add", the customer's address and each branch has an additional attribute "B_br_add", the branch's address.

Please draw the Classic Star and the Fact Constellation Schema. Then draw the example's dimension tables partitioned and normalized and use them to build a Snowflake Schema!

Solution

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

Exercises List