What is soft delete in Data Modeling?

soft delete is an important concept in Data Modeling. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.