Normalization
,Redundancy
• Storing the same information several times is called redundancy.
Redundancy leads to • Increase in size of the database • Wastage
storage space • Inconsistencies
, Anomalies in Databases
• Database anomalies, are really just unmatched or missing informati
caused by limitations or f laws within a given database. Databa
are designed to collect data and sort or present it in specific ways t
the end user. Entering or deleting information or update new reco
can cause some problems leading the database to inconsistent stat
• There are three types of anomalies.
1. Insert Anomalies
2. Update Anomalies
3. Delete Anomalies
,Redundancy
• Storing the same information several times is called redundancy.
Redundancy leads to • Increase in size of the database • Wastage
storage space • Inconsistencies
, Anomalies in Databases
• Database anomalies, are really just unmatched or missing informati
caused by limitations or f laws within a given database. Databa
are designed to collect data and sort or present it in specific ways t
the end user. Entering or deleting information or update new reco
can cause some problems leading the database to inconsistent stat
• There are three types of anomalies.
1. Insert Anomalies
2. Update Anomalies
3. Delete Anomalies
