1/4
Looks like no tags are added yet.
Insertion Anomaly
Occurs when new information cannot be added without also adding unnecessary or unrelated data. Example: You cannot add a new employee unless they are assigned to a project. Memory trick: Can't ADD.
Update Anomaly
Occurs when the same information is stored in multiple rows and must be updated everywhere to avoid inconsistencies. Example: An employee's job title changes, but only some records are updated. Memory trick: Can't CHANGE consistently.
Deletion Anomaly
Occurs when deleting one record unintentionally removes other important information. Example: Deleting the last employee assigned to a project also deletes the project's information. Memory trick: Can't DELETE without losing something else.