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. | |