CREATE TABLE SPORT
(
	TIP_SPORTA VARCHAR(30) NOT NULL,
	BROJ_DISCIPLINE NUMBER(3) NOT NULL,
	NAZIV VARCHAR(30) NOT NULL,
	MSA VARCHAR(30) NOT NULL,
	ID_SPORT NUMBER(5) PRIMARY KEY
);

CREATE TABLE DISCIPLINA
(
 SIFRA NUMBER(10) PRIMARY KEY,
 IME VARCHAR(30),
 TIP_DISCIPLINE VARCHAR(20) CHECK (TIP_DISCIPLINE IN ('POJEDINACNA','EKIPNA','KOMBINOVANA')),
 SVETSKI_REKORD NUMBER(20,2),
 OLIMPIJSKI_REKORD NUMBER(20,2),
 PROSLOGODISNJI_REZULTAT NUMBER(20),
 SVETSKI_PRVAK VARCHAR(30),
 OLIMPIJSKI_PRVAK VARCHAR(30)
 );

CREATE TABLE IMA_DISCIPLINU
(
 SIFRA_DISCIPLINE NUMBER(10) ,
 ID_SPORTA NUMBER(10),
 CONSTRAINT IMA_DISCIPLINU_PK PRIMARY KEY (SIFRA_DISCIPLINE,ID_SPORTA),
 CONSTRAINT SIFRA_DISCIPLINE_FK_IMA FOREIGN KEY (SIFRA_DISCIPLINE) REFERENCES DISCIPLINA(SIFRA),
 CONSTRAINT ID_SPORTA_FK  FOREIGN KEY (ID_SPORTA) REFERENCES SPORT(ID_SPORT)
);

CREATE TABLE TAKMICENJE
(
	NAZIV_STADIONA VARCHAR(30) NOT NULL,
	VREME_ODRZAVANJA VARCHAR (5) NOT NULL,
	DATUM_ODRZAVANJA DATE NOT NULL,
	ID_TAKMICENJE NUMBER(5) PRIMARY KEY
);