Logical Data Modeling - Entity Integrity (Uniqueness|No Duplicate|Distinct)
Table of Contents
1 - About
Entity integrity concerns the concept of:
- or no duplicate
Entity integrity is an integrity rule which states that every table must have a primary key and that the column or columns chosen to be the primary key should be unique and not null.
Asserting uniqueness of the entities within a data set implies that no:
- or relation between entity
exists more than once within the data set.
2 - Articles Related
3 - Monitoring
This attribute can be monitored two ways :
- As a static assessment, it implies applying duplicate analysis to the data set to determine if duplicate records exist
- As an ongoing monitoring process, it implies providing an identity matching and resolution service at the time of record creation to locate exact or potential matching records.
The entity integrity is a data quality metrics.