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 in­for­ma­ti­on sys­tem of a real es­ta­te com­pa­ny.

We have six di­men­si­ons with the fol­lo­wing hier­ar­chi­cal struc­tu­re:

Table L.E.64.1 - real es­ta­te

"Price" and "Num­ber of sales" are key fi­gu­res. Each real es­ta­te has an ad­di­tio­nal at­tri­bu­te "R_­re_­ad­dr", the ad­dress.

Plea­se draw the Clas­sic Star and the Fact Con­stel­la­ti­on Sche­ma. Then draw the di­men­si­on ta­bles nor­ma­li­zed and use them to build a Snowfla­ke Sche­ma!