When inserting records, we may violate:

  • Domain Constraint (Databases): if one of the attribute values provided for the new tuple is not of the specified attribute domain
  • Key Constraint (Databases): if the value of a key attribute in the new tuple already exists in another tuple in the relation
  • Referential Integrity: if a foreign key value in the new tuple references a primary key value that does not exist in the referenced relation
  • Entity Integrity: if the primary key value is null in the new tuple