title: How can anomalies (insertion,deletion and updation) be introduced into Oracle database?
body: <p>I was trying to learn Normalization in Oracle database, but struck in understanding the problem for which normalization is the solution i.e. I am unable to understand different anomalies (insertion,deletion and updation) properly. Not that, I do not know anything about them; I learned the theory from my text book (Navathe &amp; Elmsari). Anomaly is the problem raised in a database during these processes and result in inconsistent database. But I can not properly visualize it i.e. how can anomalies get introduced in the database. So, it will be very helpful if somebody comes up with a really simple database example and help me understand how can these anomalies be introduced in the database. I tried to find in the internet, but could not find good examples. </p>