The following clause is specifying a 1:M relationship between the DEPARTMENT(CODE, NAME) and EMPLOYEE tables:
CREATE TABLE EMPLOYEE (
ID INT PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
DEPARTMENT_ID NOT NULL,
FOREIGN KEY (DEPARTMENT_CODE) REFERENCES DEPARTMENT(CODE) );