dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Intermediate
Apr 22, 2020

What Is Data Integrity?

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
Hannes du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date