Can anyone explain normalization in sql and it's types

Answer 1

The point of normalization is to avoid redundant storage of the same data, in other words to avoid duplication, and instead store the unique information in separate tables, labeling each data with an ID that can be used for efficient joining (combining data).

Some resources to read more:

https://www.simplilearn.com/tutorials/sql-tutorial/what-is-normalization-in-sql

https://www.w3schools.in/dbms/database-normalization

Answer 2

OMGJay Matthews