database design

A Delete Button Needs an Answer to What Happens to Related Records

Define how deletion affects related records, user expectations and recovery before implementing the button or choosing a database cascade rule.