Give a real life example where you find the importance of foreign key

Question

Accepted Answer

Foreign keys ensure data integrity and prevent orphaned records.

Foreign keys link tables together and ensure that records in one table correspond to records in another table.
They prevent orphaned records by requiring that a record in the child table must have a corresponding record in the parent table.
For example, a foreign key in a customer orders table would link to the customer table to ensure that orders are only placed for existing customers.
Foreign keys also help with data consistency and accuracy by preventing invalid data from being entered into the database.
Overall, foreign keys are essential for maintaining data integrity and preventing errors in database operations.

Top HR questions asked in ProcessMAP