You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?
A.
A primary key
B.
An index
C.
A foreign key
D.
A unique constraint
E.
A data type
C