Define foreign key:
A foreign key is an attribute (or combination of attributes) in a table whose
values must match with a primary key in another table. The table that contains
the foreign key is called dependent table. Similarly, the table to which the
foreign key refers to is called the parent table.