Database integrity

It has been suggested that this article or section be merged with data integrity. (Discuss) Proposed since March 2011.

This article needs attention from an expert in Databases. Please add a reason or a talk parameter to this template to explain the issue with the article. WikiProject Databases may be able to help recruit an expert. (November 2008)

Database integrity ensures that data entered into the database is accurate, valid, and consistent. Any applicable integrity constraints and data validation rules must be satisfied before permitting a change to the database.

Three basic types of database integrity constraints are:

• Entity integrity, not allowing multiple 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.

See also

• Data integrity
• Bit rot