what is a foreign key is and what it is used for code example

Example: What is foreign key?

Foreign Key is a non-key attribute which is derived from the primary key 
of another table which links those tables together.