In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.
A)foreign key
B)primary key
C)complex key
D)functional key

Question

Quizplus · Accepted Answer

In a database, a foreign key is a field in one table that uniquely identifies a row of another table. In this case, the department ID in the student table is linking to the primary key in the university department table, making it a foreign key.

In a University Database, the Student Table, with Student ID