Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Wednesday Apr 22nd 2020 by Hannes du Preez
Article Image

Language: SQL, Expertise: Intermediate: Explore what the term data integrity really means.

Data integrity means ensuring data quality and that the data is traceable, searchable and recoverable. There are three types:

  • Entity Integrity: Every table must have a unique primary key
  • Referential Integrity: Foreign keys on every table must refer to primary keys on other table
  • Domain Integrity: Every column must have a specific data type and length
Mobile Site | Full Site