The image cncpt051.gif 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.