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

Question #43175
What do you mean by anamoly in database system? Why it is required? Explain the types of anamolies in database system.
Expert's answer
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.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be the first!

Leave a comment

Ask Your question

New on Blog