Star and Snowflake Schema

<b>What is A Star Schema ?</b>A Star Schema is a database schema used to store data in a star format. This schema consists of a central table called the <b>"Fact Table"</b> and a number of directly connected other table called <b>"Dimension Table". </b>The Fact Table contains information about metrics or measure while the Dimension table contains information about descriptive attributes. The Star Schema is very simple and easy to understand, making it ideal for business Intelligence applications. This Schema contains both Dimension tables and Fact Tables in it.&nbsp;<b>What is a Snowflake Schema ?</b>A Snowflake Schema is a type of database schema that is used to store data in a more complex format than the Star Schema. The Snowflake Schema consists of a central table which is called the fact table and a number of other tables which are called dimension tables.&nbsp;<b>Difference Between Star Schema and Snowflake Schema :</b>i. A Star Schema has de-normalized dimension tables, while a Snowflake Schema has normalized dimension tables.&nbsp;ii. A Star Schema is easier to design and implement than a Snowflake Schema.iii. A Star Schema can be more efficient to query than a Snowflake Schema because there are fewer <b>JOINs</b>&nbsp;between the tables.iv. A Star Schema can require more storage space than a Snowflake Schema because of the de-normalized data.&nbsp;v. A Star Schema can be difficult to update than a Snowflake Schema because of the de-normalized data.vi. A Star Schema can be more difficult to&nbsp; troubleshoot than a Snowflake Schema because of the de-normalized data.&nbsp;