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));

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));

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));

CREATE TABLE UPISAO
   (JMBAG NUMERIC(10) UNSIGNED NOT NULL,
    SIFRA NUMERIC(5) UNSIGNED NOT NULL,
    DATU DATE,
    OCJENA ENUM('1','2','3','4','5'),
    PRIMARY KEY(JMBAG,SIFRA));

INSERT INTO STUDENT SELECT * FROM fakultet.STUDENT;

INSERT INTO NASTAVNIK SELECT * FROM fakultet.NASTAVNIK;

INSERT INTO PREDMET SELECT * FROM fakultet.PREDMET;

INSERT INTO UPISAO SELECT * FROM fakultet.UPISAO;