CREATE TABLE AFDELINGEN
(AFDELING_ID INTEGER,
AFDELING_NAAM TEXT(30),
CONSTRAINT PrimaryKey PRIMARY KEY (AFDELING_ID))

CREATE TABLE CURSUSSEN
(CURSUSNR_ID INTEGER,
OMSCHRIJVING TEXT(30),
BEGINDATUM DATE,
AFDELING_ID INTEGER,
PRIMARY KEY (CURSUSNR_ID),
CONSTRAINT fkCURSUSSENAFDELINGEN FOREIGN KEY (AFDELING_ID)
REFERENCES TEAMS (TEAM_ID));