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

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