Differences

This shows you the differences between two versions of the page.

--- data_quality_dimension:referential_integrity [2023/02/19 19:33]
peter
+++ data_quality_dimension:referential_integrity [2024/03/08 13:33]
@@ Line 1: / Line 1: @@
-=====Referential integrity=====
-===Definition===
-Referential integrity of data files is the degree to which [[data_concept:data value|data values]] of the [[data_concept:primary key|primary key]] of one [[data_concept:data file|data file]] and data values of the [[data_concept:foreign key|forein key]] of another [[data_concept:data file|data file]] are equal.
-===Relations===
-Referential integrity is a [[characteristic|characteristic]] of a [[data_concept:data file|data file]] in relation to another [[data_concept:data file|data file]].
-===Example(s)===
-% of the employee records pointed to an existing department record.
-===Reference(s)===
-DAMA NL (2020). Dimensions of Data Quality (DDQ). Research paper. https://www.dama-nl.org/wp-content/uploads/2020/09/DDQ-Dimensions-of-Data-Quality-Research-Paper-version-1.2-d.d.-3-Sept-2020.pdf