Introduction to Normalization (1NF, 2NF, 3NF)
Introduction to Normalization (1NF, 2NF, 3NF)
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity. It helps in structuring tables in a way that minimizes duplication and ensures consistency.
In this lesson, you will learn the basics of normalization and understand the first three normal forms: 1NF, 2NF, and 3NF with simple examples.
What is Normalization?
Normalization is a database design technique used to divide large tables into smaller, well-structured tables while maintaining relationships between them.
Goals of normalization:
- Reduce data redundancy
- Improve data consistency
- Ensure data integrity
- Optimize database structure
First Normal Form (1NF)
A table is in First Normal Form if:
- All values are atomic (no multiple values in a single column)
- Each field contains only one value
- No repeating groups
Example (Not in 1NF):
Student_ID | Name | Subjects
1 | Amit | Math, Science
Converted to 1NF:
Student_ID | Name | Subject
1 | Amit | Math
1 | Amit | Science
Second Normal Form (2NF)
A table is in Second Normal Form if:
- It is already in 1NF
- All non-key attributes depend on the whole primary key
Example:
If a table has a composite key, all columns must depend on the full key, not part of it.
Third Normal Form (3NF)
A table is in Third Normal Form if:
- It is already in 2NF
- There are no transitive dependencies
This means non-key attributes should not depend on other non-key attributes.
Example:
Student_ID | Course_ID | Instructor_Name
Instructor_Name should be stored in a separate table to avoid dependency issues.
Real-World Example
Before Normalization:
- Duplicate student and course data
After Normalization:
- Separate tables for Students, Courses, and Enrollment
- Reduced redundancy and improved structure
Why Normalization is Important
Normalization helps you:
- Avoid duplicate data
- Improve database performance
- Maintain data accuracy
- Design scalable systems
FAQs
What is normalization in DBMS?
Normalization is the process of organizing data to reduce redundancy and improve consistency.
What is 1NF?
1NF ensures that all values in a table are atomic and there are no repeating groups.
What is 2NF?
2NF ensures that all non-key attributes depend on the full primary key.
What is 3NF?
3NF removes transitive dependencies to improve data structure.
Where can I learn more courses like this?
Click here for more free courses