What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a
value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of
the DEPARTMENT table?

A.
A check constraint on the EMPLOYEE table

B.
A unique constraint on the EMPLOYEE table WORKDEPT column

C.
A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT
column of the EMPLOYEE table

D.
A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO
column of the DEPARTMENT table