|
|
This article needs attention from an expert on the subject. See the talk page for details. 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.
[edit] See also
