Normalization Concept in Database - 1NF,2NF,3NF
This is a small video which will help you to convert the Un-normalized form of Database into a Normalized one.
Normalization is the process of splitting relations into well structured relations that allow users to insert, delete, and update records without introducing database inconsistencies.
Update, deletion, and insertion anomalies are very undesirable in any database. Anomalies are avoided by the process of normalization.
Normalization is the process for evaluating and correcting tables structures
-This minimizes the data redundancies and reduces data anomalies
Most commonly used normal forms are:
First normal form (1NF),
Second normal form (2NF),
Third normal form(3NF)
There are other normal forms like Boyce Codd Normal form(BCNF),
4NF,5NF etc.
As this course is for beginners, they are out of scope of this course.
If you have any doubts, get back to me : [email protected]