Модель БД

[T1bon]

Здравствуйте. Прошу подсказки. Верно ли смоделировал БД с внешними ключами?

CREATE TABLE DEPARTMENT(
        ID NUMBER PRIMARY KEY
	NAME	VARCHAR2(100),
);

CREATE TABLE EMPLOYEE(
  ID NUMBER PRIMARY KEY,
  DEPARTMENT_ID NUMBER,
  CHIEF_ID NUMBER,
  NAME VARCHAR2(100),
  SALARY NUMBER,
  FOREIGN KEY(CHIEF_ID) REFERENCES DEPARTMENT(ID),
  FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(ID)
)