Database Normalization and Normal Forms Explained

This presentation provides an overview of database normalization, focusing on the types and rules of normal forms, including 1NF, 2NF, and 3NF. It breaks down the key principles behind each normal form and explains how they improve data organization and efficiency in databases. Ideal for students and professionals aiming to understand structured data management.

1. Database Normalization and Normal Forms Explained

2. Normalization Normalization is a database design technique which organizes tables in a manner that reduces redundancy of data. It is also used to eliminate the undesirable characteristics like Insertion, Update and Deletion Anomalies.

3. Types of Normal Forms 1NF (First Normal Form) 2NF (Second Normal Form) 3NF (Third Normal Form)

4. 1NF Rules : Each table cell should contain a single value, and Each record needs to be unique. Example: Course Content Web HTML, PHP Programming Language C++, JAVA Course Content Web HTML Web PHP Programming Language C++ Programming Language JAVA

5. 2NF Rules : A relation will be in 2NF if it is in 1NF, and all non-key attributes are fully functional dependent on the primary key. Example: Stu-ID Stu-Name 01 A. Salam 03 A. Kalam Stu-ID Cont -ID Stu-Name Cont -name 01 01 A. Salam Robotics 03 02 A. Kalam Programming Cont -ID Cont -name 01 Robotics 02 Programming

6. 3NF Rules : A relation will be in 3NF if it is in 2NF, and no transition dependency exists. Example: Room T-ID 405 039 502 040 Room T-Name T- Dept 405 A. Karim CSE 502 A. Rahim CE T-ID T-Name T- Dept 039 A. Karim CSE 040 A. Rahim CE

7. Thanks