Validation in your app gives friendly messages. Constraints in the database give guarantees: no script, bug or second service can write a row that breaks them.