CREATE TABLE shows
(
ID              NUMBER  NOT NULL PRIMARY KEY,
NAZIV           VARCHAR2(100) NOT NULL,
BROJ_EPIZODA    NUMBER,
VRSTA_ID        VARCHAR2(100) NOT NULL,
REDATELJ        VARCHAR2(100) NOT NULL,
FIRST_REALISED  DATE    NOT NULL,

CONSTRAINT vrsta_show
    FOREIGN KEY (VRSTA_ID)
    REFERENCES   vrsta(ID)
);

CREATE TABLE vrsta
(
ID              NUMBER  NOT NULL PRIMARY KEY,
NAZIV           VARCHAR2(100) NOT NULL,
);

CREATE TABLE episode
(
ID              NUMBER  NOT NULL PRIMARY KEY,
NAZIV           VARCHAR2(100) NOT NULL,
SHOW_ID         NUMBER,
REALISED        DATE    NOT NULL,

CONSTRAINT show_episoda
    FOREIGN KEY (show_id)
    REFERENCES   showovi(ID)
);