What is Snow Flake Schema design in database ? What’s the difference between Star and Snow flake schema ?

Answer:

The denormalization of star schema is known as snow flake design.
Star schema is good when you do not have big tables in data warehousing. But when tables start becoming really huge it is better to denormalize. When you denormalize star schema it is nothing but snow flake design.