CREATE TABLE STUDENT
   (JMBAG NUMERIC(10) UNSIGNED NOT NULL,
    PREZIMES CHAR(20),
    IMES CHAR(20),
    DATR DATE,
    GODINA ENUM('1','2','3','4','5'),
    PRIMARY KEY(JMBAG))ENGINE=INNODB;

CREATE TABLE NASTAVNIK
   (OIB NUMERIC(11) UNSIGNED NOT NULL,
    PREZIMEN CHAR(20),
    IMEN CHAR(20),
    BRSOBE NUMERIC(3) UNSIGNED,
    PLACA NUMERIC(5) UNSIGNED,
    PRIMARY KEY(OIB))ENGINE=INNODB;

CREATE TABLE PREDMET
   (SIFRA NUMERIC(5) UNSIGNED NOT NULL,
    NASLOV CHAR(80),
    OIB NUMERIC(11) UNSIGNED,
    SEMESTAR ENUM('Z','L'),
    ECTS NUMERIC(2) UNSIGNED,
    PRIMARY KEY(SIFRA),
    FOREIGN KEY (OIB) REFERENCES NASTAVNIK(OIB))ENGINE=INNODB;

CREATE TABLE UPISAO
   (JMBAG NUMERIC(10) UNSIGNED NOT NULL,
    SIFRA NUMERIC(5) UNSIGNED NOT NULL,
    DATU DATE,
    OCJENA ENUM('2','3','4','5'),
    PRIMARY KEY(JMBAG,SIFRA),
    FOREIGN KEY (JMBAG) REFERENCES STUDENT(JMBAG),
    FOREIGN KEY (SIFRA) REFERENCES PREDMET(SIFRA))ENGINE=INNODB;