Looking at the diagram of the design shows a “Star” type figure with the fact table at the center, hence the name. The Snowflake Schema gets its name from an extra layer or layers of dimension tables ...