Referential integrity

Definition

Referential integrity of data files is the degree to which data values of the primary key of one data file and data values of the forein key of another data file are equal.

Relations

Referential integrity is a characteristic of a data file in relation to another 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