What is Snow Flake Schema design in database? What's the difference between Star and Snow flake schema | Eklavya Online

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

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. For instance below customeraddress table is been normalized and is a child table of Customer table. Same holds true for Salesperson table.