Example & Tutorial understanding programming in easy ways.

What is Anomaly problem?

Basically, Anomaly problem is occur when the relational table is not Normalized.


There are three types of anomaly problem in the table:

1. Insertion anomaly

2. deletion anomaly

3. updation anomaly


1. Insertion anomaly: In un-normalized table , when we insert some data then there may be chance that some data are repeated that means redundancy occur so this kind of problem is called as insertion anomaly


2. Deletion anomaly: When we delete some record of some column then there may be chance that some record automatically deleted so this kind of problem is called as deletion anomaly


3.Updation anomaly: When we want to change only one detail like one person detail then some time possible you have to update whole table in order to update one record then this is problem called as updation anomaly.


Normalization process solve the anomaly problem

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!