Explain 'Soft Delete' vs 'Hard Delete'.

Explain 'Soft Delete' vs 'Hard Delete'.

Approach: Compare flagging a record vs removing it.

A Soft Delete flags a record as deleted (e.g., is_deleted = true) but keeps it in the table. A Hard Delete permanently removes the record from the database storage.

Follow-up: Why use soft delete for customer accounts?

Key concepts: is_deleted flag, auditability.