Answer to Question #43175 in Databases | SQL | Oracle | MS Access for Rohit Arya

Question

What do you mean by anamoly in database system? Why it is required? Explain the types of anamolies in database system.

Answer 1

Database anomalies are the problems inrelations that occur due to redundancy in the relations. These anomalies affect
the process of inserting, deleting and modifying data in the relations. Some
important data may be lost if an elations is updated that contains database
anomalies. It is important to remove these anomalies in order to perform
different processing on the relations without any problem.

Redundancy is the duplication of the data.

There are 3 types of anomalies.

Insert Anomaly: When you insert a record withouthaving it stored on the related record.

Delete Anomaly: When you delete some informationand lose valuable related information at the same time.

Update Anomaly: Any change made to your datawill require you to scan all records to make the changes multiple times.