Enforcing Database Integrity

The integrity of a database is comprised of two elements: entity and referential integrity. Entity integrity requires that all primary keys must be unique within a table, and referential integrity dictates that all foreign keys must have corresponding values within a base table's primary key. Although the normalization process creates entity and referential integrity, either the RDBMS itself or your application must maintain that integrity during the data-entry process. Failure to maintain database integrity can result in erroneous data values and, ultimately, widespread corruption of the entire database.

Ensuring Entity Integrity and Auditability

Database managers differ widely in their capabilities to maintain entity ...

Get Special Edition Using Access 97, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.