Database Design
Data and Referential Integrity
- Referential Integrity:
- Referential integrity is specified in the form of deletion rules as follows:
- No restriction.
- Any record in the table may be deleted without regard to any records in any other tables.
- Delete:Cascade.
- A deletion of a record in the table must be automatically followed by the deletion of matching records in a related table.
- Delete:Restrict.
- A deletion of a record in the table must be disallowed until any matching records are deleted from a related table.