20.3k views
4 votes
Orphan record example?

User Narvoxx
by
4.2k points

1 Answer

4 votes

Answer:

If we delete record number 15 in a primary table, but there's still a related table with the value of 15, we end up with an orphaned record. Here, the related table contains a foreign key value that doesn't exist in the primary key field of the primary table. This has resulted in an “orphaned record”.

User Dmitry Gusev
by
4.4k points