Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition

Relationship-Level Integrity

This type of integrity ensures the following:

• The connection between the two tables (or key fields) in a relationship is sound.

• You can insert new records into each table in a meaningful manner.

• You can delete an existing record without producing any adverse affects.

• There is a meaningful limit to the number of records that can be interrelated within the relationship.