Choose Index below for a list of all words and phrases defined in this glossary.

Referential Integrity

index | Index

Referential integrity - definitions

Referential integrity : Integrity constraints that govern the relationship of an occurrence of one entity type or file to one or more occurrences of another entity type or file, such as the relationship of a customer to the orders that customer may place. Referential integrity defines constraints for creating, updating, or deleting occurrences of either or both files. 

[Category=Data Quality ]

Source: Larry English, External, 08-Feb-2009 12:09

These advertisers support this free service

Referential integrity -

   1) A series of rules that defines and manages the link between parent and child records.
   2) A state in which all the tables in the database are consistent with each other.
   3) The facility of any DBMS that ensures the validity of predefined relationships. 

[Category=Database Management ]

Source: Northwest Database Services, 14 November 2009 10:56:32, External

Referential integrity - The concept of enforced relationships between tables based on the definition of a primary key and foreign key. The existence of a value in one dataset is dependent on the existance of the same value in another linked dataset. Referential Integrity implements rules in a relational-database schemes that are used to preserve the relationships between tables when you add or delete records. For example, a state may not be deleted from a table containing states if any address records include that state.

[Category=Data Governance ]

Source: The Data Governance Institute, 21 December 2009 10:21:47, External

Referential integrity - [Category=Data Quality ] A mechanism for ensuring that data remains accurate and consistent as a database changes. When changes are made to a table related to another table by a common key, the changes are automatically reflected in both tables.

[Category=Geospatial ]

Source: esri, 29 July 2012 09:51:14, External

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: