DEPTNO IS THE DEPARTMENT WITH WHICH THE EMPLOYEE IS ASSOCIATED. TH...

11. DEPTNO is the department with which the employee is associated. The

column is defined in the same way as the DEPT table’s primary key column

of DEPTNO, and the constraint EMP_DEPTNO_FK enforces a foreign key

relationship; it is not possible to assign an employee to a department that

does not exist. This is nullable, however.