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