Consider the two tables Student and Department with attributes given below.

Student

Student Id

Name

Course

$1022$

John Smith

Course $1$

$1031$

Rebecca James

Course $2$

Department

Department Name

Student Id

Science

$1022$

Arts

$1043$

The Student Id in the Department table is a $\_\_\_\_\_\_\_.$

Foreign key

Primary key

Primary key as well as a foreign key