Constraints ⇒ drafts not managed by DBMS

Consider all those times you have filled out a form and something goes wrong and you have to fill it out from scratch again. It is better for database management systems to manage all data (including data as it is entered – i.e. drafts). Inadequate persistence is an anti-pattern.

Another advantage of allowing drafts to be recorded is that it simplifies application code: no distinction needs to be made between an editor of a new record and an editor of an existing record.