Keep References Connected

A foreign key requires values in referencing columns to match a candidate key in the referenced table. orders.customer_id therefore points only to an existing customers.id. Rejecting unmatched values prevents child rows from becoming orphans.