An HR system includes a Departments table and an Employees t…
An HR system includes a Departments table and an Employees table. Each employee record includes a field called DepartmentID that matches an entry in the Departments table. What role does DepartmentID play in the Employees table? Options:A. Primary KeyB. Candidate KeyC. Foreign KeyD. Surrogate Key Correct Answer: C. Foreign Key Explanation:DepartmentID links each employee to a department by referencing the Departments table. It is not unique in the Employees table, so it isn’t a primary or candidate key. Surrogate keys are artificial IDs, not cross-table references.