Scribd
Upload
7 views5 pages

Database Normalization Explained

Uploaded by

sriramneha369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
7 views5 pages

Database Normalization Explained

Uploaded by

sriramneha369
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Normalization in Database (1NF,

2NF, 3NF)
Student, Employee, and Library
Tables
Unnormalized Table
• ROLL NO | NAME | ROLE |
DEPARTMENT | BOOKS ISSUED | SALARY |
DESIGNATION
• 1 | Student A | Student | CS |
Book1, Book2 | - | -
• 22 | Employee B | Employee | Admin |
- | 50000 | Manager
• 45 | Librarian C| Library | - | Book3
|- |-
1NF (First Normal Form)
• 1NF ensures each column contains atomic
values (no repeating groups):

• ROLL NO | NAME | ROLE |


DEPARTMENT | BOOK ISSUED | SALARY |
DESIGNATION
• 1 | Student A | Student | CS |
Book1 |- |-
• 1 | Student A | Student | CS |
Book2 |- |-
2NF (Second Normal Form)
• 2NF eliminates partial dependency by
decomposing tables:

• PERSON Table:
• ROLL NO | NAME | ROLE |
DEPARTMENT | SALARY | DESIGNATION
• 1 | Student A | Student | CS |-
|-
• 22 | Employee B | Employee | Admin |
50000 | Manager
3NF (Third Normal Form)
• 3NF eliminates transitive dependency:

• PERSON Table:
• ROLL NO | NAME | ROLE |
DEPARTMENT | SALARY | DESIGNATION
• 1 | Student A | Student | CS |-
|-
• 22 | Employee B | Employee | Admin |
50000 | Manager

You might also like