Anomalies

Deletion Anomaly

• Deleting something takes away information that should not be deleted

Insertion Anomaly

• The insertion of something is restricted behind the insertion of something that it shouldn't be
• You may need to add a null values to a table in poor form to add an attribute to it, and in that case the attribute would be better in its own relation

Consider the table (ID, name, salary, dept_name, dept_fund)

In this table, adding a new department would involve adding a new employee as well

Update Anomaly

• Updating something can cause an update something else that shouldn't be happening