An UPDATE overwrites the past. Then someone asks who changed this email? or which plan was Sara on in August?, and the database has no answer. History and audit tables keep every change, so you can explain what happened, and sometimes undo it.