Data Integrity (database)

Data integrity is about ensuring all data is consistent and accurate throughout a database.

Referential integrity ensures all foreign keys have a primary key in another table.

Entity integrity ensures all records have a unique identifier, the primary key.

Domain integrity ensures all attributes have a valid value which are within the required type and that are atomic (singular).