Basically, there are thee type of anomaly problem occurs in the relation tables:
2. Deletion anomaly
2. updation 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.
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 →