Baza Studentska Sluzba V

CREATE DATABASE stud_sluzba;
use stud_sluzba;
CREATE TABLE ìspitni_rok` (
ÌD_ROKA` int(11) NOT NULL AUTO_INCREMENT,
`NAZIV` varchar(15) NOT NULL,
`SKOLSKA_GOD` varchar(7) NOT NULL,
`STATUS_ROKA` enum('redovni','vanredni') NOT NULL,
PRIMARY KEY (ÌD_ROKA`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;
CREATE TABLE `profesor` (

ÌD_PROFESORA` int(11) NOT NULL,
ÌME` varchar(25) NOT NULL,
`PREZIME` varchar(50) NOT NULL,
`ZVANJE` enum('dr','mr') NOT NULL,
`DATUM_ZAP` date NOT NULL,
PRIMARY KEY (ÌD_PROFESORA`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `predmet` (

ÌD_PREDMETA` int(11) NOT NULL,
ÌD_PROFESORA` int(11) NOT NULL,
`NAZIV` varchar(50) NOT NULL,
ÈSPB` int(11) NOT NULL,
`STATUS` enum('obavezan','izborni') NOT NULL,
PRIMARY KEY (ÌD_PREDMETA`)
CREATE TABLE ìspit` (

ÌD_ISPITA` int(11) NOT NULL AUTO_INCREMENT,
ÌD_ROKA` int(11) NOT NULL,
`DATUM` date NOT NULL,
PRIMARY KEY (ÌD_ISPITA`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4;
CREATE TABLE `student` (

ÌD_STUDENTA` int(11) NOT NULL,
ÌME` varchar(25) NOT NULL,
`PREZIME` varchar(40) NOT NULL,
`SMER` varchar(5) NOT NULL,
`BROJ` int(11) NOT NULL,
`GODINA_UPISA` varchar(4) NOT NULL,
PRIMARY KEY (ÌD_STUDENTA`)
CREATE TABLE `student_predmet` (

`SKOLSKA_GODINA` varchar(7) NOT NULL,
PRIMARY KEY (ÌD_STUDENTA`,ÌD_PREDMETA`,`SKOLSKA_GODINA`)
CREATE TABLE `zapisnik` (
ÌD_ISPITA` int(11) NOT NULL,
ÒCENA` int(11) NOT NULL,
`BODOVI` varchar(3) NOT NULL,
PRIMARY KEY (ÌD_STUDENTA`,ÌD_ISPITA`)
alter table PREDMET add constraint FK_PREDMET_RELATIONS_PROFESOR foreign key

(ID_PROFESORA)
references PROFESOR (ID_PROFESORA) on delete restrict on update restrict;
alter table STUDENT_PREDMET add constraint FK_STUDENT__RELATIONS_STUDENT foreign

key (ID_STUDENTA)
references STUDENT (ID_STUDENTA) on delete restrict on update restrict;
alter table STUDENT_PREDMET add constraint FK_STUDENT__RELATIONS_PREDMET foreign

key (ID_PREDMETA)
references PREDMET (ID_PREDMETA) on delete restrict on update restrict;
alter table ZAPISNIK add constraint FK_ZAPISNIK_RELATIONS_STUDENT foreign key

(ID_STUDENTA)
references STUDENT (ID_STUDENTA) on delete restrict on update restrict;
alter table ZAPISNIK add constraint FK_ZAPISNIK_RELATIONS_ISPITI foreign key

(ID_ISPITA)
references ISPIT (ID_ISPITA) on delete restrict on update restrict;
alter table ISPIT add constraint FK_ISPITI_RELATIONS_ISPITNI_ foreign key (ID_ROKA)

references ISPITNI_ROK (ID_ROKA) on delete restrict on update restrict;
alter table ISPIT add constraint FK_ISPITI_RELATIONS_PREDMET foreign key

(ID_PREDMETA)
references PREDMET (ID_PREDMETA) on delete restrict on update restrict;
INSERT INTO `student` (ÌD_STUDENTA`,ÌME`,`PREZIME`,`SMER`,`BROJ`,`GODINA_UPISA`)

VALUES (1,'Sara ','Miljković','NRT ',33,'2020');
VALUES (2,'Marko','Bakić','ASUV',2,'2019');
VALUES (3,'Andrej','Lazić','NRT ',16,'2020');
VALUES (4,'Lazar','Marković','RT',12,'2020');
VALUES (5,'Andjela','Stanković','IS',3,'2020');
VALUES (6,'Miloš','Petrović','RT',25,'2019');
VALUES (7,'Marko','Rakić','ELITE',6,'2020');
VALUES (8,'Lena','Milić','IS',10,'2018');
VALUES (9,'Stefan','Nikolić','NRT',15,'2019');
VALUES (10,'Aleksandar','Markić','ELITE',11,'2019');
VALUES (11,'Nikola','Milutinović','ASUV',26,'2020');
VALUES (12,'Violeta','Grujić','IS',13,'2019');
VALUES (13,'Bojana','Tomić','NRT',96,'2020');
VALUES (14,'Aleksa','Todorović','RT',55,'2019');
VALUES (15,'Igor','Tadić','ELITE',35,'2018');
VALUES (16,'Petra','Kostić','IS',7,'2020');
VALUES (17,'Vuk','Mirković','NRT',3,'2020');
VALUES (18,'Branislav ','Vuletić','ASUV',61,'2019');
VALUES (19,'Nenad','Branković','RT',23,'2018');
VALUES (20,'Mateja','Stojković','IS',14,'2018');
VALUES (21,'Jovana','Minić','IS',72,'2019');
VALUES (22,'Milica','Đukić','NRT',32,'2020');
VALUES (23,'Filip','Jevtić','RT',29,'2018');
VALUES (24,'Dragan','Popović','ELITE',19,'2019');
VALUES (25,'Željko','Marković','ASUV',67,'2018');
VALUES (26,'Janko','Lekić','NRT',85,'2019');
VALUES (27,'Nikola','Obradović','IS',101,'2020');
VALUES (28,'Todor','Pantić','ELITE',68,'2019');
VALUES (29,'Nada','Ilić','IS',16,'2020');
VALUES (30,'Lara','Ivanović','NRT',17,'2019');
INSERT INTO `profesor` (ÌD_PROFESORA`,ÌME`,`PREZIME`,`ZVANJE`, `DATUM_ZAP`)

VALUES (100,'Gordana','Vuletić','dr', '2002-10-01');
VALUES (101,'Miloš','Lazarević','dr', '1997-03-15');
VALUES (102,'Goran','Protić','mr', '1986-09-27');
VALUES (103,'Lazar','Gojković','dr', '2002-11-05');
VALUES (104,'Bojan','Mikić','mr', '2006-07-22');
VALUES (105,'Jelena','Pekić','mr', '2014-04-18');
VALUES (106,'Marijana','Petrović','dr', '1996-08-20');
VALUES (107,'Nemanja','Marković','dr', '2017-11-30');
VALUES (108,'Marko','Bojović','mr', '1979-12-25');
VALUES (109,'Dragan','Mirčetić','dr', '2000-05-16');
VALUES (110,'Milovan','Kovačević','dr', '2002-07-29');
VALUES (111,'Nada','Stanimirović','dr', '2011-04-26');
VALUES (112,'Vladimir','Vuletić','dr', '2015-08-01');
VALUES (113,'Radmila','Lekić','dr', '2019-05-20');
VALUES (114,'Bogdan','Prokić','mr', '1983-06-18');
VALUES (115,'Tomislav','Miljković','dr', '1998-09-03');
VALUES (116,'Željko','Jokić','dr', '2016-02-12');
VALUES (117,'Marija','Vasić','mr', '2006-07-22');
VALUES (118,'Aleksandra','Grozdić','dr', '1974-08-31');
VALUES (119,'Miloš','Stanković','dr', '1989-06-26');
VALUES (120,'Nikola','Žiletić','mr', '1993-09-07');
INSERT INTO `predmet` (ÌD_PREDMETA`,ÌD_PROFESORA`,`NAZIV`,ÈSPB`,`STATUS`) VALUES

(1259,107,'Inženjerska matematika',7,'obavezan');
(1589,117,'Programiranje računarskih igara',6,'izborni');
(2458,115,'Verovatnoća i statistika',6,'izborni');
(2569,105,'Baze podataka',6,'obavezan');
(2648,104,'Operativni sistemi 1',6,'izborni');
(3264,114,'Objektno programiranje 1',6,'izborni');
(3521,112,'Aplikativni softver',6,'izborni');
(4238,118,'Digitalne multimedije',6,'izborni');
(4296,110,'Elektrotehnika',7,'obavezan');
(4526,101,'Uvod u objektno programiranje',6,'izborni');
(4851,119,'Programski jezici',6,'izborni');
(5214,102,'Veb dizajn',6,'izborni');
(5236,111,'Programiranje mobilnih uređaja',6,'izborni');
(6345,116,'Mikroračunari',6,'izborni');
(6752,103,'Mikrokontroleri',6,'izborni');
(7526,108,'Računarske mreže',6,'izborni');
(7584,109,'Interakcija čovek-računar',6,'izborni');
(8546,113,'Objektno programiranje 2 ',6,'izborni');
(9412,106,'Analogna elektronika',6,'izborni');
(9542,120,'Mikroprocesorski softver',6,'izborni');
INSERT INTO `student_predmet` (ìd_studenta`,ìd_predmeta`,`skolska_godina`) VALUES

(1,3521,'2018/19');
(1,4238,'2018/19');
(2,2458,'2018/19');
(2,5214,'2018/19');
(3,1259,'2018/19');
(3,3264,'2019/20');
(3,4851,'2019/20');
(3,5214,'2019/20');
(3,1589,'2019/20');
(3,6752,'2019/20');
(3,3521,'2019/20');
(4,1589,'2018/19');
(4,9542,'2018/19');
(4,8546,'2018/19');
(4,5214,'2018/19');
(4,4851,'2018/19');
(4,7526,'2018/19');
(4,7584,'2018/19');
(4,3521,'2018/19');
(4,6752,'2018/19');
(5,4851,'2018/19');
(5,7584,'2018/19');
(5,7526,'2019/20');
(6,8546,'2018/19');
(6,6345,'2019/20');
(6,2458,'2019/20');
(6,3264,'2019/20');
(6,4238,'2019/20');
(6,4296,'2019/20');
(6,2569,'2019/20');
(6,9542,'2019/20');
(6,5236,'2019/20');
(7,1259,'2018/19');
(7,1589,'2018/19');
(7,6752,'2018/19');
(7,7584,'2018/19');
(7,8546,'2018/19');
(7,4851,'2019/20');
(7,5214,'2019/20');
(8,3264,'2018/19');
(8,2569,'2019/20');
(8,4851,'2019/20');
(9,1259,'2018/19');
(9,5214,'2019/20');
(10,7584,'2018/19');
(10,8546,'2018/19');
(10,4851,'2018/19');
(10,2648,'2018/19');
(10,3521,'2018/19');
(10,5214,'2018/19');
(10,4238,'2018/19');
(10,5236,'2018/19');
(10,9542,'2018/19');
(11,1589,'2018/19');
(11,2648,'2018/19');
(11,3521,'2018/19');
(11,4238,'2018/19');
(11,6752,'2018/19');
(11,7584,'2018/19');
(11,3264,'2019/20');
(11,7526,'2019/20');
(11,9412,'2019/20');
(12,3521,'2018/19');
(13,4526,'2018/19');
(13,4851,'2018/19');
(14,1589,'2018/19');
(14,2648,'2018/19');
(14,3521,'2018/19');
(14,5214,'2018/19');
(14,2569,'2019/20');
(14,3264,'2019/20');
(14,6345,'2019/20');
(14,8546,'2019/20');
(15,9542,'2019/20');
(16,1259,'2018/19');
(16,1589,'2018/19');
(16,2648,'2018/19');
(16,3521,'2018/19');
(16,4238,'2018/19');
(16,5214,'2018/19');
(16,3264,'2019/20');
(16,6345,'2019/20');
(16,8546,'2019/20');
(17,9412,'2019/20');
(18,6752,'2019/20');
(19,4851,'2018/19');
(19,5236,'2018/19');
(19,7526,'2019/20');
(20,1259,'2018/19');
(20,1589,'2018/19');
(20,2458,'2018/19');
(20,2648,'2018/19');
(20,3521,'2018/19');
(20,4238,'2018/19');
(20,7584,'2018/19');
(20,6345,'2019/20');
(20,8546,'2019/20');
(21,1259,'2018/19');
(21,1589,'2018/19');
(21,6752,'2018/19');
(21,7584,'2018/19');
(21,9542,'2018/19');
(21,4851,'2019/20');
(21,5214,'2019/20');
(21,8546,'2019/20');
(22,1259,'2018/19');
(23,4238,'2018/19');
(23,2569,'2019/20');
(24,2648,'2018/19');
(24,4238,'2018/19');
(24,5236,'2018/19');
(25,1259,'2018/19');
(25,1589,'2018/19');
(25,2648,'2018/19');
(25,3521,'2018/19');
(25,7584,'2018/19');
(25,8546,'2018/19');
(25,3264,'2019/20');
(25,7526,'2019/20');
(26,1259,'2018/19');
(26,2458,'2018/19');
(26,3264,'2018/19');
(26,4238,'2018/19');
(26,4296,'2018/19');
(26,2569,'2018/19');
(26,8546,'2018/19');
(26,5214,'2018/19');
(26,4851,'2018/19');
(27,2458,'2019/20');
(27,3264,'2019/20');
(28,4851,'2018/19');
(28,1259,'2018/19');
(28,1589,'2018/19');
(28,6752,'2018/19');
(28,7584,'2018/19');
(28,9542,'2018/19');
(28,5214,'2018/19');
(28,8546,'2018/19');
(28,3264,'2018/19');
(29,4526,'2018/19');
(29,6752,'2018/19');
(29,5236,'2018/19');
(29,7526,'2018/19');
(29,4851,'2018/19');
(29,6345,'2018/19');
(29,8546,'2018/19');
(29,1259,'2018/19');
(29,1589,'2018/19');
(29,3521,'2018/19');
(29,7584,'2018/19');
(30,1259,'2018/19');
(30,1589,'2018/19');
(30,2648,'2018/19');
(30,3521,'2018/19');
(30,6752,'2018/19');
(30,7584,'2018/19');
(30,8546,'2018/19');
(30,9542,'2018/19');
(30,7526,'2019/20');
INSERT INTO ìspitni_rok` (ÌD_ROKA`,`NAZIV`,`SKOLSKA_GOD`,`STATUS_ROKA`) VALUES

(1,'Januar','2018/19','redovni');
(2,'Februar','2018/19','redovni');
(3,'Jun','2018/19','redovni');
(4,'Septembar','2018/19','redovni');
(5,'Oktobar','2018/19','redovni');
(6,'Oktobar 2','2018/19','vanredni');
(7,'Novembar','2018/19','vanredni');
(8,'Januar','2019/20','redovni');
(9,'Februar','2019/20','redovni');
(10,'Jun','2019/20','redovni');
(11,'Septembar','2019/20','redovni');
(12,'Oktobar','2019/20','redovni');
(13,'Oktobar 2','2019/20','vanredni');
INSERT INTO ìspit`(ÌD_ISPITA`,ÌD_ROKA`,ÌD_PREDMETA`,`DATUM`) VALUES
(1,1,2458,'2019-01-30');
(2,2,3264,'2019-02-18');
(3,5,4238,'2019-09-17');
(4,6,4296,'2019-10-11');
(5,7,1259,'2019-11-07');
(6,8,2569,'2020-02-01');
(7,11,9542,'2020-09-09');
(8,13,9412,'2020-10-12');
(9,10,6752,'2020-06-16');
(10,5,5236,'2019-09-20');
(11,6,7584,'2019-09-12');
(12,4,8546,'2019-09-06');
(13,8,4851,'2020-02-03');
(14,7,2648,'2019-11-07');
(15,1,1589,'2019-02-01');
(16,1,1259,'2019-02-03');
(17,2,3521,'2019-02-14');
(18,9,5214,'2020-02-18');
(19,5,4238,'2019-09-24');
(20,3,6752,'2019-06-13');
(21,6,5236,'2019-10-13');
(22,12,7526,'2020-09-21');
(23,13,4851,'2020-10-11');
(24,11,6345,'2020-09-06');
(25,10,8546,'2020-06-21');
(26,1,9542,'2019-02-04');
(27,2,7584,'2019-02-24');
(28,3,4851,'2019-06-18');
(29,3,2648,'2019-06-12');
(30,6,1589,'2019-10-12');
(31,5,5214,'2019-09-23');
(32,7,4238,'2019-11-07');
(33,9,3264,'2020-02-18');
(34,8,2458,'2020-01-30');
(35,10,4296,'2020-06-21');
(36,13,2648,'2020-10-11');
(37,11,3264,'2020-09-04');
(38,4,4526,'2019-09-03');
(39,6,7584,'2019-10-13');
(40,1,5236,'2019-02-04');
INSERT INTO `zapisnik` (ÌD_STUDENTA`,ÌD_ISPITA`,ÒCENA`,`BODOVI`) VALUES

(1,3,7,'63');
(1,17,6,'51');
(2,1,10,'96');
(2,31,5,'33');
(3,16,9,'82');
(3,33,9,'89');
(3,5,7,'62');
(3,28,10,'91');
(3,31,6,'59');
(3,17,8,'75');
(4,26,6,'56');
(4,30,7,'67');
(4,25,5,'47');
(4,31,9,'87');
(4,28,6,'54');
(4,22,10,'97');
(4,9,8,'77');
(4,39,9,'93');
(5,11,10,'99');
(5,22,5,'45');
(5,28,6,'51');
(6,12,10,'93');
(6,24,10,'96');
(6,10,10,'91');
(6,2,6,'54');
(6,1,8,'76');
(6,7,8,'79');
(6,3,9,'85');
(6,4,5,'40');
(8,2,8,'76');
(8,6,9,'87');
(8,13,6,'56');
(9,16,6,'58');
(9,18,7,'61');
(10,27,7,'66');
(10,19,7,'69');
(10,17,8,'72');
(10,12,10,'96');
(10,7,5,'32');
(10,10,9,'98');
(10,13,7,'64');
(10,14,10,'93');
(11,3,9,'87');
(11,8,8,'71');
(11,17,8,'71');
(11,20,6,'71');
(11,22,7,'61');
(11,27,7,'61');
(11,29,8,'75');
(11,30,8,'75');
(11,33,6,'51');
(12,17,8,'71');
(13,28,9,'86');
(13,38,10,'91');
(14,6,10,'97');
(14,14,6,'52');
(15,7,5,'10');
(16,14,8,'71');
(16,16,5,'25');
(16,17,7,'61');
(16,19,5,'15');
(16,24,7,'61');
(16,25,6,'71');
(16,30,8,'75');
(16,31,9,'87');
(16,33,6,'51');
(17,8,10,'98');
(18,9,10,'100');
(19,22,7,'65');
(19,28,8,'79');
(19,40,9,'89');
(20,1,9,'87');
(20,5,6,'71');
(20,17,8,'71');
(20,24,8,'71');
(20,25,7,'68');
(20,27,7,'61');
(20,29,7,'61');
(20,30,6,'51');
(20,32,8,'75');
(21,5,8,'77');
(21,9,7,'64');
(21,39,9,'81');
(21,26,10,'99');
(21,31,10,'92');
(21,25,6,'58');
(22,16,6,'52');
(23,3,10,'92');
(23,6,9,'87');
(24,19,7,'61');
(24,29,10,'91');
(24,40,7,'65');
(25,5,9,'87');
(26,5,6,'51');
(26,1,10,'93');
(26,6,9,'87');
(26,2,10,'91');
(26,31,7,'63');
(26,28,7,'67');
(27,33,9,'86');
(27,34,5,'20');
(28,28,9,'85');
(28,5,9,'84');
(28,15,10,'100');
(28,9,8,'75');
(28,39,7,'65');
(28,26,10,'94');
(28,31,9,'85');
(28,25,6,'55');
(28,2,5,'41');
(29,38,10,'99');
(29,21,8,'79');
(29,25,7,'65');
(29,20,6,'59');
(29,22,10,'94');
(29,24,7,'67');
(29,23,10,'97');
(29,11,5,'27');
(29,5,6,'51');
(29,15,7,'61');
(29,17,5,'45');
(30,26,5,'15');
(30,5,8,'74');
(30,15,9,'82');
(30,36,10,'96');
(30,17,5,'41');
(30,22,9,'89');

Baza Studentska Sluzba V

Uploaded by

Copyright:

Available Formats

Baza Studentska Sluzba V

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Baza Studentska Sluzba V

Uploaded by

Copyright:

Available Formats

CREATE DATABASE stud_sluzba;

CREATE TABLE `profesor` (

CREATE TABLE `predmet` (

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `ispit` (

CREATE TABLE `student` (

CREATE TABLE `student_predmet` (

alter table PREDMET add constraint FK_PREDMET_RELATIONS_PROFESOR foreign key

alter table STUDENT_PREDMET add constraint FK_STUDENT__RELATIONS_STUDENT foreign

alter table STUDENT_PREDMET add constraint FK_STUDENT__RELATIONS_PREDMET foreign

alter table ZAPISNIK add constraint FK_ZAPISNIK_RELATIONS_STUDENT foreign key

alter table ZAPISNIK add constraint FK_ZAPISNIK_RELATIONS_ISPITI foreign key

alter table ISPIT add constraint FK_ISPITI_RELATIONS_ISPITNI_ foreign key (ID_ROKA)

alter table ISPIT add constraint FK_ISPITI_RELATIONS_PREDMET foreign key

INSERT INTO `student` (`ID_STUDENTA`,`IME`,`PREZIME`,`SMER`,`BROJ`,`GODINA_UPISA`)

INSERT INTO `profesor` (`ID_PROFESORA`,`IME`,`PREZIME`,`ZVANJE`, `DATUM_ZAP`)

INSERT INTO `predmet` (ÌD_PREDMETA`,ÌD_PROFESORA`,`NAZIV`,ÈSPB`,`STATUS`) VALUES

INSERT INTO `student_predmet` (`id_studenta`,`id_predmeta`,`skolska_godina`) VALUES

INSERT INTO `ispitni_rok` (`ID_ROKA`,`NAZIV`,`SKOLSKA_GOD`,`STATUS_ROKA`) VALUES

INSERT INTO `zapisnik` (ÌD_STUDENTA`,ÌD_ISPITA`,ÒCENA`,`BODOVI`) VALUES

You might also like