Normalization

There are two types of popular Normalization techniques.

Star Normalization and Snowflake Normalization

 

Star Normalization

In Star Normalization, different interrelated tables refer to a single common table containing relationship of all tables. This is a very benifitial technique as during query writing, you need not to join too many tables to reach desired data.

 

Snowflake Normalization

Snowflake normalization refers to a technique of normalization where one table’s column refers to the other columns primary key, which in turn refers to the third one, thus creating a snowflake like structure. In such structure, whenever the data from lowest in hierarchy is required to be grouped with top level table, all tables are to be traversed, which create unnecessary load on the data server.

 

ALWAYS USE STAR NORMALIZATION WHILE DESIGNING DATABASE