The Deletion Anomaly

• A deletion anomaly occurs when you delete a record that may contain attributes that shouldn't be deleted

This time we are keeping track of rental units, our long time tenant 236 leaves when we delete her/his record we loose the fact that we own unit 20