Database integrity

From Wikipedia, the free encyclopedia

This article or section is in need of attention from an expert on the subject. WikiProject Computer science or the Computer science Portal may be able to help recruit one. If a more appropriate WikiProject or portal exists, please adjust this template accordingly.

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, 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.

[edit] See also

• data integrity