| Referential Integrity |
|
|
|
|
|
|
|
|
|
|
|
|
| The use of
foreign keys can lead to |
|||||||||||
| inconsistency in
the database: |
|||||||||||
| – | A foreign key
value without a matching |
||||||||||
| primary key value |
|||||||||||
| – | Changing a
primary key value that is |
||||||||||
| referenced as a
foreign key |
|||||||||||
| – | Deleting a record
whose primary key value is |
||||||||||
| referenced as a
foreign key |
|||||||||||