Model baze podataka

Snow
Forest

Tabela DOSIJE

INDEKS IME PREZIME GOD_RODJENJA
20100021 Milos Peric 1992
20100022 Marijana Savkovic 1993
20100023 Sanja Terzic 1991
20100024 Nikola Vukovic 1992
20100025 Predrag Popovic 1991
20100026 Zorica Miladinovic 1993

Tabela PEDMET

ID_PREDMETA SIFRA NAZIV KREDITI
1001 M111 Analiza 1 6
1002 M112 Analiza 2 6
1003 M113 Analiza 3 6
1021 M131 Geometrija 6
1101 M105 Diskretne strukture 1 6
1102 M106 Diskretne strukture 2 6
2001 P101 Programiranje 1 8
2002 P102 Programiranje 2 8
2003 P103 Objektno orijentisano programiranje 6
2004 P104 Algoritmi i strukture podataka 6
3001 S1 Engleski jezik 1 5
3002 S2 Engleski jezik 2 5
4001 R101 Uvod u organizaciju racunara 5
4002 R102 Uvod u Veb i Internet tehnologije 5

Tabela ISPITNI_ROK

GODINA_ROKA OZNAKA_ROKA NAZIV
2011 jan Januar 2011
2011 feb Februar 2011
2011 apr April 2011
2011 jun Jun 2011
2011 sep Septembar 2011
2011 okt Oktobar 2011

Tabela ISPIT

INDEKS ID_PREDMETA GODINA_ROKA OZNAKA_ROKA OCENA DATUM_ISPITA
20100021 1001 2011 jan 9 Jan 20, 2011
20100022 1001 2011 jan 8 Jan 20, 2011
20100023 1001 2011 jan 8 Jan 20, 2011
20100024 1001 2011 jan 10 Jan 20, 2011
20100025 1001 2011 jan 6 Jan 20, 2011
20100026 1001 2011 jan 5 Jan 20, 2011
20100021 2001 2011 jan 10 Jan 25, 2011
20100022 2001 2011 jan 9 Jan 25, 2011
20100023 2001 2011 jan 8 Jan 25, 2011
20100024 2001 2011 jan 7 Jan 25, 2011
20100025 2001 2011 jan 5 Jan 25, 2011
20100021 3001 2011 jan 7 Jan 27, 2011
20100023 3001 2011 jan 5 Jan 27, 2011
20100024 3001 2011 jan 6 Jan 28, 2011
20100026 3001 2011 jan 6 Jan 28, 2011
20100026 1001 2011 feb 7 Feb 10, 2011
20100025 2001 2011 feb 6 Feb 10, 2011
20100026 2001 2011 feb 7 Feb 10, 2011
20100021 1021 2011 apr 7 Apr 3, 2011
20100022 1021 2011 apr 5 Apr 3, 2011
20100023 1021 2011 apr 10 Apr 3, 2011
20100024 1021 2011 apr 6 Apr 3, 2011
20100026 1021 2011 apr 8 Apr 3, 2011