Answer to Question #169658 in Databases | SQL | Oracle | MS Access for william

Question

What are anomalies of data and how anomalies will remove from the Database?

Answer 1

Anomalies of data: It is poorly planned database which is not in the normalized condition, in this, all data are stored in one table which is also called flat file database. Mostly the anomalies occur due to the redundancy of data.

Data anomalies are of three types-

• Update anomalies
• Insertion anomalies
• Deletion anomalies

Normalize the data and split the table into small relational table which reduce the redundancy in data and the data anomalies also will be reduced.