Data Integrity is having correct and accurate data in your database.When we are storing data in the database we don't want repeating values, we don't want incorrect values or broken relationships between tables.
TYPES OF INTEGRITY CONSTRAINTS
Domain Integrity
Entity Integrity
Referential Integrity
Tuple Integrity
Key Integrity
Entity Integrity
Each row for an entity in a table should be uniquely identified
Some record is saved in the database then that record should be uniquely identified from others.This is done with the help of primary keys. The entity constraint says that the value of the primary key should not be NULL.
Referential Integrity is used to maintain the data consistency between two tables.
Rules are made in the database structure about how foreign keys should be used to ensure that changes, addition and deletion in the database maintain the data integrity:
https://youtu.be/ovWIouehsJE
Hey there, We are Blossom Themes! We are trying to provide you the new way to look and use the blogger templates. Our designers are working hard and pushing the boundaries of possibilities to widen the horizon of the regular templates and provide high quality blogger templates to all hardworking bloggers!
0 Comments