Data Integrity means maintaining accurate, reliable and consistent data during any operation.
· Entity Integrity
It ensures that each row in a table must be unique identified by an attribute, called primary key
· Domain Integrity
It ensures that only a valid range of values is allowed to be stored in a column. It restricts the type of data, range of values and format of data.
· Referential Integrity
It ensures that all the values in the foreign key match the values in primary key.
· User-Defined Integrity
It enforces the data integrity on tables in two ways by defining constraints or by defining rules.
No comments:
Post a Comment