Scribd
Upload
30 views20 pages

Normalization

The document discusses normalization in Database Management Systems (DBMS), focusing on the various normal forms: 1NF, 2NF, 3NF, and BCNF. It explains the concept of anomalies in DBMS, including update, insert, and delete anomalies, and provides examples for each normal form. Additionally, it includes practical examples to illustrate the normalization process.

Uploaded by

Ratish Patil
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
30 views20 pages

Normalization

The document discusses normalization in Database Management Systems (DBMS), focusing on the various normal forms: 1NF, 2NF, 3NF, and BCNF. It explains the concept of anomalies in DBMS, including update, insert, and delete anomalies, and provides examples for each normal form. Additionally, it includes practical examples to illustrate the normalization process.

Uploaded by

Ratish Patil
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
You are on page 1/ 20

Normalization in

DBMS:
1NF, 2NF, 3NF and
BCNF
By Sumedha A. Maindalkar
Normalization
Anomalies in DBMS
Example
Update anomaly :
Insert anomaly :
Delete anomaly :
Normalization
First Normal form (1NF)
First Normal form (1NF)
Second Normal form (2NF)
Second Normal form (2NF): example
Second Normal form (2NF): example
Third Normal form (3NF)
Third Normal form (3NF): example
Third Normal form (3NF)
Boyce Codd Normal form (BCNF)
Boyce Codd Normal form (BCNF):
example
Boyce Codd Normal form (BCNF):
example
Solve some
Normalization
Examples

You might also like