Answer to Question #43175 in Databases | SQL | Oracle | MS Access for Rohit Arya
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!