Example & Tutorial understanding programming in easy ways.

What is Insertion anomaly?

Basically, there are thee type of anomaly problem occurs in the relation tables:


1.Insertion anomaly

2. Deletion anomaly

2. updation anomaly


1.Insertion anomaly:

When some record are repeated in the table at the time of insertion of another record then this problem is called as insertion anomaly.


Example:

Let assume we have a table in which we store the information of student with their HOD details also. so whenever new student take admission we insert detail into table but we also insert HOD detail, but HOD is same for all student and we repeat record of HOD for all student then it is redundancy problem and called as insertion anomaly.


Read More →