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

Exercise No. 60: Real Estate III (log)

This cube stores data of an information system of a real estate company.

We have six dimensions with the following hierarchical structure:

Table L.E.64.1 - real estate

"Price" and "Number of sales" are key figures. Each real estate has an additional attribute "R_re_addr", the address.

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