An update may violate the domain and NOT NULL constraint on an attribute being modified.
And any other constraint may also be violated depending on the attribute being updated:
- Updating primary key : similar to a
DELETE, followed byINSERT - Updating a foreign key : may violate Referential Integrity
- Updating an ordinary attribute: can only violate Domain Constraint (Databases)