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.

Get Database Design for Mere Mortals™: A Hands-On Guide to Relational Database Design, Second Edition now with O’Reilly online learning.

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