There are two types of data modeling schemas:

1. Star Schema: It is the purest form of schema consisting of a fact table in the center referencing multiple dimension tables around it. In this, all the dimension tables are connected to the fact table, and in the fact table, the primary key acts as a foreign key.

2. Snowflake Schema: This is a bit of a complicated schema with an increased level of the normalization process. The fact table remains the same as in the star schema, but the dimension tables are normalized. Due to the presence of multiple levels of dimension tables, it is named as a snowflake.

BY Best Interview Question ON 01 Jul 2020