| Cascade Delete |
The action of automatically deleting all dependent records in child tables when a record in the parent table is deleted. |
| Data Anomaly |
An inconsistency or irregularity in the data stored in a database, which violates one or more integrity constraints. |
| Data Integrity |
The accuracy, consistency, and reliability of data stored in a database. |
| 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. |
| Domain Integrity |
The integrity constraints that enforce valid data entry for a given column, ensuring that values meet specified criteria. |
| Entity Integrity |
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. |
| Integrity Constraint |
A rule applied to data in a database to maintain its integrity and prevent invalid or inconsistent data from being stored. |
| Orphaned Record |
A record in a child table that doesn't have a corresponding record in the parent table. |
| Referential Integrity |
RThe integrity constraints that ensure the consistency between related tables by enforcing rules on foreign key values. |
