Printer Friendly
Dictionary, Encyclopedia and Thesaurus - The Free Dictionary
1,778,375,578 visitors served.
forum mailing list For webmasters
?
New: Language forums
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

referential integrity

   Also found in: Acronyms, Wikipedia 0.01 sec.

referential integrity

A database management safeguard that ensures every foreign key matches a primary key. For example, customer numbers in a customer file are the primary keys, and customer numbers in the order file are the foreign keys. If a customer record is deleted, the order records must also be deleted; otherwise they are left without a primary reference. If the DBMS does not test for this, it must be programmed into the applications.

(database)referential integrity - A collection of properties which should be possessed by data in a relational database.

For example, in a database of family members, if we enter A as a spouse of B, we should also enter B as a spouse of A. Similarly, if we remove one end of the relationship we should also remove the other.


How to thank TFD for its existence? Tell a friend about us, add a link to this page, add the site to iGoogle, or visit webmaster's page for free fun content.
?Page tools
Printer friendly
Cite / link
 Email
Feedback
? Mentioned in ? References in periodicals archive
 
Without properly correlating the backup and recovery processes, each database may maintain independent referential integrity, but the correlation between the two may be lost.
Planning for backup and recovery: the key elements for a successful ... by Dow, James / Computer Technology Review
stale logins) and checks the referential integrity of user names.
DATABASE SCANNER MANAGES SECURITY OF MICROSOFT SERVERS by Online Product News
the ability to split a table into two tables and maintain full referential integrity
New SQL Refactor From Red Gate Delivers "Must-Have" Functionality for ... by Business Wire
More results
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2009 Farlex, Inc.
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional. Terms of Use.