Database - What is normalization?

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.
Database - What is denormalization?
The process of adding redundant data to get rid of complex join, in order to optimize database performance.....
Database - Explain DML and DDL statements
Data definition language is used to define and manage all attributes and properties of a database....
Database - What is Union and Union All operator?
UNION is a set operator combines the relations of 2 or more select statements into one relation....
Post your comment