Data Integrity
Ref:
Data Integrity is the assurance that data a consistent, accurate, reliable and accessible.
“Guilty until proven innocent” approach
Types of integrity constraint:
- Entity integrity: within table (primary key)
- Referential integrity: inter table relationship (foreign key)
- Domain integrity
- User-defined integrity