Each dimension table is connected to the fact table by a single foreign key, forming a star-like shape. A snowflake schema is a variation of the star schema that normalizes the dimension tables ...