When updating information requires changes in multiple rows.

When a new record cannot be added due to a missing value in a required field.

When redundant data is present across multiple rows.

When deleting a row causes unintended data loss.