=====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 [[general_term:characteristic|characteristic]] of a [[data_concept:data file|data file]] in relation to another |[[data_concept:data file|data file]]| ===Example(s)=== 98% 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}}