Explain the key concepts that are involved in supporting data integrity in a database. How is integrity enforced? What are the advantages of enforcing integrity? What are the disadvantages? How do integrity constraints impact the overall application design?© BrainMass Inc. brainmass.com March 4, 2021, 6:01 pm ad1c9bdddf
Data Integrity is an umbrella term that refers to the consistency, accuracy, and correctness of data stored in a database. It is not about physical security, fault tolerance, or data preservation (backups). Data integrity implies that a user can correctly and consistently navigate and manipulate the tables in the database. There are two basic rules to ensure data integrity
(i) Entity integrity: This rule states that the value of the primary key can never be a null value (a null value is one that has no value and is not the same ...
The solution describes key concepts that support data integrity in a database.