Types of Data Integrity

Data Integrity falls into the following categories
Entity integrity
Entity integrity ensures that each row can be uniquely identified by an attribute called the Primary key. The Primary key cannot have a NULL value.
Domain integrity
Domain integrity refers to the range of valid entries for a given column. It ensures that there are only valid entries in the column.
Referential integrity

Referential integrity ensures that for every value of a Foreign key, there is a matching value of the Primary key.

0 comments