The Reliability and accuracy of data is called the data integrity.
Types of Data Integrity in DBMS:
- Entity integrity
- Domain integrity
- Referential integrity
- User defined integrity
1. Entity Integrity:
The basic idea of entity integrity is that each should have acolumn that uniquely identifies the remaining columns in the table.
2. Domain Integrity:
It refers to the range of values that are allowed for the column.
3. Referential Integrity:
It refers to the relationships between the columns of a table.
4. User Defined Integrity:
It allows the user or administrator to enforce the new business rules which does not falls under above integrity.
No comments:
Post a Comment