Database dom 2

CREATE TABLE `kurs` (
  `SifK` int(11) NOT NULL,
  `Naziv` text NOT NULL,
  `BrKredita` int(11) NOT NULL,
  `SifO` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



CREATE TABLE `odsek` (
  `SifO` int(11) NOT NULL,
  `Naziv` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



CREATE TABLE `pohadja` (
  `SifS` int(11) NOT NULL,
  `SifR` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `preduslov` (
  `SifK` int(11) NOT NULL,
  `SifKP` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



CREATE TABLE `profesor` (
  `SifP` int(11) NOT NULL,
  `Ime` text NOT NULL,
  `SifO` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;



CREATE TABLE `raspored` (
  `SifR` int(11) NOT NULL,
  `SifP` int(11) NOT NULL,
  `SifK` int(11) NOT NULL,
  `SifU` int(11) NOT NULL,
  `Termin` text NOT NULL,
  `Dan` date NOT NULL,
  `Br.Prijavljenih` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `student` (
  `SifS` int(11) NOT NULL,
  `Ime` text NOT NULL,
  `BrIndeksa` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `ucionica` (
  `SifU` int(11) NOT NULL,
  `BrMesta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


ALTER TABLE `kurs`
  ADD PRIMARY KEY (`SifK`),
  ADD KEY `SifO` (`SifO`),
  ADD KEY `SifO_2` (`SifO`);


ALTER TABLE `odsek`
  ADD PRIMARY KEY (`SifO`);


ALTER TABLE `pohadja`
  ADD KEY `SifR` (`SifR`);


ALTER TABLE `preduslov`
  ADD PRIMARY KEY (`SifK`);


ALTER TABLE `profesor`
  ADD PRIMARY KEY (`SifP`),
  ADD KEY `SifO` (`SifO`);


ALTER TABLE `raspored`
  ADD PRIMARY KEY (`SifR`),
  ADD KEY `SifP` (`SifP`),
  ADD KEY `SifK` (`SifK`),
  ADD KEY `SifU` (`SifU`);


ALTER TABLE `student`
  ADD PRIMARY KEY (`SifS`);


ALTER TABLE `ucionica`
  ADD PRIMARY KEY (`SifU`);


ALTER TABLE `kurs`
  MODIFY `SifK` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `odsek`
  MODIFY `SifO` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `preduslov`
  MODIFY `SifK` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `profesor`
  MODIFY `SifP` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `raspored`
  MODIFY `SifR` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `student`
  MODIFY `SifS` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `ucionica`
  MODIFY `SifU` int(11) NOT NULL AUTO_INCREMENT;


ALTER TABLE `kurs`
  ADD CONSTRAINT `kurs_ibfk_1` FOREIGN KEY (`SifO`) REFERENCES `odsek` (`SifO`);


ALTER TABLE `pohadja`
  ADD CONSTRAINT `pohadja_ibfk_1` FOREIGN KEY (`SifR`) REFERENCES `raspored` (`SifR`);


ALTER TABLE `profesor`
  ADD CONSTRAINT `profesor_ibfk_1` FOREIGN KEY (`SifO`) REFERENCES `odsek` (`SifO`);


ALTER TABLE `raspored`
  ADD CONSTRAINT `raspored_ibfk_1` FOREIGN KEY (`SifP`) REFERENCES `profesor` (`SifP`),
  ADD CONSTRAINT `raspored_ibfk_2` FOREIGN KEY (`SifK`) REFERENCES `kurs` (`SifK`),
  ADD CONSTRAINT `raspored_ibfk_3` FOREIGN KEY (`SifU`) REFERENCES `ucionica` (`SifU`);