A FOREIGN KEY is a key in another table that relates from the PRIMARY KEY in the parent table. A Foreign Key is needed in the related table to connect data from the primary table.
Let's take a look at the following example
From the above table, Smith has taken the course Math 101 and the other three English 101.
Here's how to create Foreign Key and Primary Key.
ALTER TABLE Syntax
TO REMOVE FOREIGN KEY