There is a relationship between the Identification table and the Academic table. You could describe the relationship by saying the entries in Identification have an Academic record. A Primary Key is a field or collection of fields whose value uniquely identifies each record in a table. In the Identification table the StudentNumber is the Primary Key. In the Academic table, it is the Course that is the primary key.
Primary keys can be in any position in a table.
A Foreign Key is a primary key from one table that is included in a second table in order to establish a relationship between the two tables. It is also called a common field. There are several different kinds of relationships that may exist. One student record can be associated with many Academic records. Each prof has many students, and each student may have many IS profs at one time.