The DeptID field in an employee table must match the DeptID of an existing record in the department table . This is an example of:
A) key integrity
B) domain integrity
C) referential integrity
D) logical integrity
E) schema integrity

Question

Quizplus · Accepted Answer

This is an example of referential integrity, which ensures that a foreign key in one table matches a primary key in another table, maintaining consistency between related tables.

The DeptID Field in an Employee Table Must Match the DeptID