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 →
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!