DATA NORMALIZATION

Data normalization is a process ude to organize a database in to tables and colomns

REASONS FOR DATABASE NORMALIZATION

• To minimize duplicate data
• To avoid data modification
• To simplify query

DATA DUPLICATION AND MODIFICATION ANOMALIES

• It increases storage and decrease performance
• It becomes more difficult to maintain data changes

DIFFERENT KIND OF ANOMALIES

• Insert anomaly
• Update anomaly
• Deletion anomaly

THREE COMMON FORMS OF DATABASE NORMALIZATION

• First normal form
• Second normal form

• Third normal form

• Reference