What is a foreign key ?

An attribute that appears as a non-prime key attribute in one relation and as a prime key attribute (or part of primary key) in another relation is called foreign key.