Dimensional modeling (part 4): hierachies and bridge tables; multivalued dimensions; fact tables of types transaction, periodic snapshot, and accumulating snapshot; modeling recommendations; rules to follow; mistakes to avoid.