This illustration shows tables DEPT and EMP.

Table DEPT has three columns:

• DEPTNO
• DNAME
• LOC

Each value in the DNAME column must be unique.

Table EMP has six columns:

• EMPNO
• ENAME
• ... Other Columns ...
• SAL
• COMM
• DEPTNO

Each row must have a value for the ENAME column. Each row must have a value for the EMPNO column, and the value must be unique. Each value in the DEPTNO column must match a value in the DEPTNO column of the DEPT table. Each value in the SAL column must be lower than 10,000.