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.


   
Top


Database Design for Mere Mortals[c] A Hands-On Guide to Relational Database Design
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
ISBN: 0201694719
EAN: 2147483647
Year: 2002
Pages: 203

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net