Just add a column Active_Status or IsActive. This will serve the purpose in every cases. When you have more data. more complex logic.

Trigger gives us problem whenever you will use...