What are the different types of anomalies in database normalization?

What are the different types of anomalies in database normalization?

The different types of anomalies in database normalization are:

1. Insertion Anomaly: This occurs when it is not possible to insert data into a table without also inserting data into another table.

2. Update Anomaly: This occurs when updating data in a table results in inconsistencies or errors in the database.

3. Deletion Anomaly: This occurs when deleting data from a table unintentionally removes other necessary data.

These anomalies can be eliminated or minimized through the process of database normalization, which involves organizing data into multiple tables and establishing relationships between them.