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