What is normalization? - Normalization is the way of organizing data in a database by removing redundancy and inconsistent dependency.
- Database normalization has the rules to be followed while creating databases.Each rule is called as normal form.
First Normal form states - Remove duplicate column and identify each set of related data with a primary key.
Second normal form - Create relationship between master and master detail tables using foreign key.
Third normal form - Remove the fields that do not depend on the primary key.
- It is the process of organizing data into related table.
- To normalize database, we divide database into tables and establish relationships between the tables.
- It reduces redundancy. It is done to improve performance of query.
What is normalization?Normalization is the technique for designing database tables to eliminate data redundancy, to safe guard the database against certain anomalies (structural problems). It is a step-by-step breakdown of data structure complexity into simple structure that facilitates no loss to information and relationship.