• Gists

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
© 2018 - 2021 imantung.github.io. All Rights Reserved.