DATA INTEGRITY
Whereas data security is about protecting the database against unauthorised users, data integrity is about protecting the database against authorised users. As stated in Chapter 2, one of the roles of a database management system is to allow constraints on data to be defined and to enforce those constraints. It is these constraints that ensure that the data remains consistent and complies with the business rules.
Integrity constraints fall into two categories: those that are inherent in the underlying model of the database management system and those that are encoded into the logical schema.
The inherent constraint rules for all relational databases are, for example:
All candidate keys are unique; that is, no duplication is allowed. ...
Get Principles of Data Management now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
