Integrity constraints
From Wikipedia, the free encyclopedia
Integrity constraints are used to ensure accuracy and consistency of data in a relational database. Data integrity is handled in a relational database through the concept of referential integrity. There are many types of integrity constraints that play a role in referential integrity.
Codd, initially defined two sets of constraints, but in his second version of the relational model, he came up with five integrity constraints:
- Entity integrity
- Referential Integrity
- Domain Integrity
- Column Integrity
- User Defined Integrity