Entity Integrity Referential Integrity
Domain Integrity Orphaned Record
Cascade Delete Data Integrity
Data Anomaly Integrity Constraint

 

RThe integrity constraints that ensure the consistency between related tables by enforcing rules on foreign key values. The integrity constraints that ensure that no primary key value can be null or empty, and that each primary key value is unique in a table.
A record in a child table that doesn't have a corresponding record in the parent table. The integrity constraints that enforce valid data entry for a given column, ensuring that values meet specified criteria.
The accuracy, consistency, and reliability of data stored in a database. The action of automatically deleting all dependent records in child tables when a record in the parent table is deleted.
A rule applied to data in a database to maintain its integrity and prevent invalid or inconsistent data from being stored. An inconsistency or irregularity in the data stored in a database, which violates one or more integrity constraints.

 

Data Validation

 

The process of ensuring that data entered into a database meets specified criteria or constraints, preventing the storage of inaccurate or inconsistent data.