SQL연습-02DDL,제약조건2

CREATE TABLE DEPT_CONST(
  DEPTNO NUMBER(2) CONSTRAINT DEPTCONST_DETPNO_PK PRIMARY KEY,
  DNAME VARCHAR2(14),
  LOC VARCHAR2(13) CONSTRAINT DEPTCONST_LOC_NN NOT NULL,
  CONSTRAINT DEPTCONST_DNAME_UNQ UNIQUE(DNAME)
  );

CREATE TABLE EMP_CONST(
  EMPNO NUMBER(4),
  ENAME VARCHAR2(10) CONSTRAINT EMPCONST_ENAME_NN NOT NULL,
  JOB VARCHAR2(9),
  TEL VARCHAR2(20),
  HIREDATE DATE,
  SAL NUMBER(7) CONSTRAINT EMPCONT_SAL_CHK CHECK(SAL BETWEEN 1000 AND 9999),
  COMM NUMBER(7),
  DEPTNO NUMBER(2),
  CONSTRAINT EMPCONST_EMPNO_PK PRIMARY KEY(EMPNO),
  CONSTRAINT EMPCONST_TEL_UNQ UNIQUE(TEL),
  CONSTRAINT EMPCONST_DEPTNO_FK FOREIGN KEY(DEPTNO) REFERENCES DEPT_CONST(DEPTNO)
  );