Normalization is the process of designing a data model to efficiently store data in a database
- Database normalization is a data design and organization process applied to data structures based on rules that help building relational databases.
- In relational database design, the process of organizing data to minimize redundancy is called normalization.
- Normalization usually involves dividing a database into two or more tables and defining relationships between the tables.
- The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.
What are the Different Normalization Forms?
1NF - Make a separate table for each set of
related attributes, and give each table a primary key. Each field
contains at most one value from its attribute domain.
2NF -If an attribute depends on only part of a multi-valued key, then remove it to a separate table.
3NF -If attributes do not contribute to a
description of the key, then remove them to a separate table. All
attributes must be directly dependent on the primary key.
Rules for 3NF
Rules for 3NF
- To separate table for each set of related attributes, and give a primary key for each table.
- If an attribute depends on only part of a multi-valued key, remove it to a separate table
- If attributes do not contribute to a description of the key, remove them to a separate table.
