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