Tutorials -> Dimensional Modeling Tutorials

Snowflake Schema Design

If we did not de-normalize our dimensions into one table each, then the schema would have looked like this
 

You can see,  this looks like a snow flake, hence this type of schema is called Snowflake Schema.  General rule of thumb is keep away from snow flake schemas as even though they may save you some space, they will cost a lot in terms of query times.

Next>> Step By Step Design
 

Common Misspellings: snoflake schema, sno flake schema, snow flake schema