Relationship-Level Integrity

  Previous section   Next section

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.


Part II: The Design Process