DBMS Normalization (1NF, 2NF, 3NF) — Easy Guide with Examples
Introduction Normalization in DBMS is a process used to organize data in a database to reduce redundancy and improve data integrity. It divides large tables into smaller, related tables and removes data duplication. Normalization is performed in steps called Normal Forms : First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF) Let’s understand each in a simple way. What is Normalization? Normalization is the process of structuring a database to: Remove data redundancy Avoid update anomalies Improve data consistency Maintain data integrity It is mainly used in Relational Database Management Systems (RDBMS) . 🔹 First Normal Form (1NF) Rule of 1NF A table is in First Normal Form (1NF) if: Each field contains atomic (single) values No repeating groups or multivalued attributes Each record is unique Example (Not in 1NF) Students table StudentID Name ...
Comments
Post a Comment