SNOWFLAKE AND STAR SCHEMA

The snowflake schema is made up of one fact table connected to many dimension tables, each of which can be linked to another dimension table via a many-to-one relationship. In a snowflake schema, the fact table remains in the middle, surrounded by dimension tables. Tables in a snowflake schema are often normalized to the third normal form. However, each dimension table is further divided down into numerous related tables, resulting in a snowflake-like hierarchical structure.A star schema is a relational database schema consisting of a single, central fact table surrounded by dimension tables. The picture below depicts a star schema with a single fact table and four dimension tables. A star schema can contain any number of dimension tables. The branches at the ends of the connections connecting the tables represent a many-to-one relationship between the fact table and each dimension table.The key distinction between the star schema and the snowflake schema is that the snowflake schema's dimension table is stored in normalized form to reduce redundancy.