Logical Data Modeling - Data Integrity

About

Data/Database integrity ensures that data entered into the database is:

• accurate,
• correct (valid),
• and consistent.

Three basic types of integrity are:

• Entity integrity, allowing no two rows to have the same identity within a table.
• Domain integrity, restricting data to predefined data types, e.g.: dates.
• Referential integrity, requiring the existence of a related row in another table, e.g. a customer for a given customer ID.

Articles Related

Constraint

Integrity is enforce with the help of constraint

Any applicable integrity constraints and data validation rules must be satisfied before permitting a change to the database.

See also: Relational Data Modeling - (Integrity) (Constraints|action assertions)