Snowflake Schema Design

If we did not de-normalize our dimensions into one table each, then the schema would look like Fig. 1

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 time.