O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required