Database Design
Data and Referential Integrity
- Domain Integrity:
- Appropriate controls must be designed to ensure that no field takes on a value that is outside of the range of legal values.
- Referential Integrity:
- A referential integrity error exists when a foreign key value in one table has no matching primary key value in the related table.