What role does a foreign key play in the establishment of a relationship between two entities or tables?

A foreign key is a relationship or link between two tables which ensures that the data stored in a database is consistent.