Differences

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

--- data_quality_dimension:referential_integrity [2023/02/19 18:08]
peter
+++ data_quality_dimension:referential_integrity [2024/03/08 13:33] (current)
@@ Line 2: / Line 2: @@
 ===Definition===
-Referntial integrity of data files The degree to which [[data_concept:data value|data values]] of the primary key of one [[data_concept:data file|data file]] and data values of the foreign key of another [[data_concept:data file|data file]] are equal.
+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===
-Referntial integrity is a [[characteristic|characteristic]] of two [[data_concept:data file|data file]]
+|Referential integrity| is a [[general_term: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.
+% of the employee records pointed to a 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
+{{tag>All DataQualityDimension}}