What is orphan record?

An orphan record is a data entry in a database that does not have a corresponding related entry in another table, often due to deletion or data integrity issues. For instance, if a record in a child table references a parent record that has been deleted, the child record becomes an orphan. This can lead to inconsistent data and may violate referential integrity constraints. Managing orphan records is essential for maintaining the accuracy and reliability of a database.