Data Integrity

Ref:

• https://en.wikipedia.org/wiki/Data_integrity
• https://database.guide/what-is-data-integrity/

Data Integrity is the assurance that data a consistent, accurate, reliable and accessible.

“Guilty until proven innocent” approach

Types of integrity constraint:

1. Entity integrity: within table (primary key)
2. Referential integrity: inter table relationship (foreign key)
3. Domain integrity
4. User-defined integrity