· 6 years ago · May 20, 2019, 02:48 PM
1
2------------------------------------------------UPITI ZA DROPOVANE SHEMA, TABELA, SEQUENCI------------------------------------------------
3
4IF EXISTS (SELECT schema_id FROM sys.schemas WHERE [name] = 'HR_Sluzba')
5BEGIN
6 IF OBJECT_ID('[HR_Sluzba].[Parametar_pripada]', 'U') IS NOT NULL
7 BEGIN
8 IF OBJECT_ID ('HR_Sluzba.FK_PARAMETAR_PRIPADA_PRIPADA', 'F') IS NOT NULL
9 BEGIN
10 ALTER TABLE [HR_Sluzba].[Parametar_pripada] DROP CONSTRAINT FK_PARAMETAR_PRIPADA_PRIPADA;
11 END
12 IF OBJECT_ID ('HR_Sluzba.FK_PARAMETAR_PRIPADA_IMA_PARAMETAR', 'F') IS NOT NULL
13 BEGIN
14 ALTER TABLE [HR_Sluzba].[Parametar_pripada] DROP CONSTRAINT FK_PARAMETAR_PRIPADA_IMA_PARAMETAR;
15 END
16
17 DROP TABLE [HR_Sluzba].[Parametar_pripada]
18 END
19
20 IF OBJECT_ID('[HR_Sluzba].[Pripada]', 'U') IS NOT NULL
21 BEGIN
22 IF OBJECT_ID ('HR_Sluzba.FK_PRIPADA_EVALUACIONI_TEST', 'F') IS NOT NULL
23 BEGIN
24 ALTER TABLE [HR_Sluzba].[Pripada] DROP CONSTRAINT FK_PRIPADA_EVALUACIONI_TEST;
25 END
26 IF OBJECT_ID ('HR_Sluzba.FK_PRIPADA_TIP_TESTA', 'F') IS NOT NULL
27 BEGIN
28 ALTER TABLE [HR_Sluzba].[Pripada] DROP CONSTRAINT FK_PRIPADA_TIP_TESTA;
29 END
30
31 DROP TABLE [HR_Sluzba].[Pripada];
32 END
33
34 IF OBJECT_ID('[HR_Sluzba].[Ima_Parametar]', 'U') IS NOT NULL
35 BEGIN
36 IF OBJECT_ID('HR_Sluzba.FK_IMA_PARAMETAR_PARAMETAR','F') IS NOT NULL
37 BEGIN
38 ALTER TABLE [HR_Sluzba].[Ima_Parametar] DROP CONSTRAINT FK_IMA_PARAMETAR_PARAMETAR;
39 END
40 IF OBJECT_ID ('HR_Sluzba.FK_IMA_PARAMETAR_TIP_TESTA', 'F') IS NOT NULL
41 BEGIN
42 ALTER TABLE [HR_Sluzba].[Ima_Parametar] DROP CONSTRAINT FK_IMA_PARAMETAR_TIP_TESTA;
43 END
44
45 DROP TABLE [HR_Sluzba].[Ima_Parametar];
46 END
47
48
49 IF OBJECT_ID('[HR_Sluzba].[Tip_evaluacionog_testa]', 'U') IS NOT NULL
50 BEGIN
51 DROP TABLE [HR_Sluzba].[Tip_evaluacionog_testa];
52
53 IF OBJECT_ID ('HR_Sluzba.Tip_Evaluacionog_testa_Sequence', 'SO') IS NOT NULL
54 BEGIN
55 DROP SEQUENCE HR_Sluzba.Tip_Evaluacionog_testa_Sequence;
56 END
57 END
58
59 IF OBJECT_ID('[HR_Sluzba].[Evaluacioni_Test]', 'U') IS NOT NULL
60 BEGIN
61 IF OBJECT_ID ('HR_Sluzba.FK_EVALUACIONI_TEST_ZAPOSLENI', 'F') IS NOT NULL
62 BEGIN
63 ALTER TABLE [HR_Sluzba].[Evaluacioni_Test] DROP CONSTRAINT FK_EVALUACIONI_TEST_ZAPOSLENI;
64 END
65
66 DROP TABLE [HR_Sluzba].[Evaluacioni_Test];
67
68 IF OBJECT_ID ('HR_Sluzba.Evaluacioni_test_Sequence', 'SO') IS NOT NULL
69 BEGIN
70 DROP SEQUENCE HR_Sluzba.Evaluacioni_test_Sequence;
71 END
72 END
73
74 IF OBJECT_ID('[HR_Sluzba].[Zaposlen]', 'U') IS NOT NULL
75 BEGIN
76 IF OBJECT_ID('HR_Sluzba.FK_Zaposlen_Kandidat', 'F') IS NOT NULL
77 BEGIN
78 ALTER TABLE [HR_Sluzba].[Zaposlen] DROP CONSTRAINT FK_Zaposlen_Kandidat;
79 END
80 DROP TABLE [HR_Sluzba].[Zaposlen];
81 END
82
83
84 IF OBJECT_ID('[HR_Sluzba].[Parametar]', 'U') IS NOT NULL
85 BEGIN
86 DROP TABLE [HR_Sluzba].[Parametar];
87
88 IF OBJECT_ID ('HR_Sluzba.Parametar_Sequence', 'SO') IS NOT NULL
89 BEGIN
90 DROP SEQUENCE HR_Sluzba.Parametar_Sequence;
91 END
92 END
93
94
95 IF OBJECT_ID('[HR_Sluzba].[Kandidat]', 'U') IS NOT NULL
96 BEGIN
97 DROP TABLE [HR_Sluzba].[Kandidat];
98
99 IF OBJECT_ID ('HR_Sluzba.Kandidat_Sequence', 'SO') IS NOT NULL
100 BEGIN
101 DROP SEQUENCE HR_Sluzba.Kandidat_Sequence;
102 END
103 END
104
105
106 DROP SCHEMA [HR_Sluzba];
107END;
108GO
109CREATE SCHEMA [HR_Sluzba];
110GO
111
112---------------------------------------------------UPITI ZA KREIRANJE SEQUENCI---------------------------------------------------
113
114CREATE SEQUENCE [HR_Sluzba].[Parametar_Sequence]
115 AS int
116 start with 0
117 increment by 1
118 cycle;
119
120
121CREATE SEQUENCE [HR_Sluzba].[Tip_Evaluacionog_testa_Sequence]
122 AS int
123 start with 0
124 increment by 1
125 cycle;
126
127CREATE SEQUENCE [HR_Sluzba].[Evaluacioni_test_Sequence]
128 AS int
129 start with 0
130 increment by 1
131 cycle;
132
133CREATE SEQUENCE [HR_Sluzba].[Kandidat_Sequence]
134 AS int
135 start with 1
136 increment by 1
137 minvalue 1
138 maxvalue 10000
139 cycle;
140
141---------------------------------------------------UPITI ZA KREIRANJE TABELA---------------------------------------------------
142
143CREATE TABLE [HR_Sluzba].[Parametar]
144(
145 [id_parametra] NUMERIC(5),
146 [kriterijum_evaluacije] NVARCHAR(75) NOT NULL,
147 CONSTRAINT PK_Parametar_id_parametra PRIMARY KEY (id_parametra)
148);
149GO
150
151ALTER TABLE [HR_Sluzba].[Parametar]
152 ADD CONSTRAINT DFT_ID_PARAMETAR DEFAULT(next value for [HR_Sluzba].[Parametar_Sequence]) for id_parametra;
153
154CREATE TABLE [HR_Sluzba].[Tip_evaluacionog_testa]
155(
156 [id_tipa_evaluacionog_testa] NUMERIC(5),
157 [vrsta_testa] NVARCHAR(50) NOT NULL,
158 CONSTRAINT PK_TIP_EVALUACIONOG_TESTA_id_tipa_evaluacionog_testa PRIMARY KEY(id_tipa_evaluacionog_testa)
159);
160GO
161
162
163ALTER TABLE [HR_Sluzba].[Tip_evaluacionog_testa]
164 ADD CONSTRAINT DFT_ID_TIP_TESTA DEFAULT(next value for [HR_Sluzba].[Tip_Evaluacionog_testa_Sequence]) for id_tipa_evaluacionog_testa;
165
166
167
168CREATE TABLE [HR_Sluzba].[Ima_Parametar]
169(
170 [id_parametra] NUMERIC(5),
171 [id_tipa_evaluacionog_testa] NUMERIC(5),
172 CONSTRAINT FK_IMA_PARAMETAR_PARAMETAR FOREIGN KEY (id_parametra)
173 REFERENCES [HR_Sluzba].[Parametar](id_parametra),
174 CONSTRAINT FK_IMA_PARAMETAR_TIP_TESTA FOREIGN KEY (id_tipa_evaluacionog_testa)
175 REFERENCES [HR_Sluzba].[Tip_Evaluacionog_testa](id_tipa_evaluacionog_testa),
176 CONSTRAINT PK_IMA_PARAMETAR PRIMARY KEY (id_parametra,id_tipa_evaluacionog_testa)
177);
178GO
179
180
181CREATE TABLE [HR_Sluzba].[Kandidat] (
182 k_id NUMERIC(5) default (next value for HR_Sluzba.Kandidat_sequence),
183 k_jmbg NUMERIC(13) not null,
184 k_ime VARCHAR(15) not null,
185 k_prezime CHAR(15) not null,
186 k_datrodj DATE not null,
187 k_pol VARCHAR(1) not null,
188 k_email CHAR(50) not null,
189 k_broj CHAR(15) not null,
190 k_drzv_stal CHAR(15) not null,
191 k_grad_stal CHAR(15) not null,
192 k_adres_stal CHAR(50) not null,
193 k_drzv_preb CHAR(15),
194 k_grad_preb CHAR(15),
195 k_adres_preb CHAR(50),
196 CONSTRAINT PK_Kandidat_k_id PRIMARY KEY (k_id),
197 CONSTRAINT UQ_Kandidat_k_jmbg unique (k_jmbg),
198 CONSTRAINT UQ_Kandidat_k_email unique (k_email),
199 CONSTRAINT UQ_Kandidat_k_broj unique (k_broj),
200 CONSTRAINT CH_Kandidat_k_jmbg CHECK (len(k_jmbg) = 13),
201 CONSTRAINT CH_Kandidat_k_datrodj CHECK (DATEDIFF(day, k_datrodj, CAST(current_timestamp as DATE)) > 0),
202 CONSTRAINT CK_Kandidat_k_pol CHECK (k_pol in ('m', 'M', 'z', 'Z'))
203);
204
205CREATE TABLE [HR_Sluzba].[Zaposlen] (
206 k_id NUMERIC(5),
207 mbr NUMERIC(13),
208 z_jmbg NUMERIC(13) not null,
209 z_ime VARCHAR(15) not null,
210 z_prezime CHAR(15) not null,
211 z_datrodj DATE not null,
212 z_pol VARCHAR(1) not null,
213 z_email CHAR(50) not null,
214 z_broj CHAR(15) not null,
215 z_drzv_stal CHAR(15) not null,
216 z_grad_stal CHAR(15) not null,
217 z_adres_stal CHAR(50) not null,
218 z_drzv_preb CHAR(15),
219 z_grad_preb CHAR(15),
220 z_adres_preb CHAR(50),
221 z_datum_zap DATE not null,
222 CONSTRAINT UQ_Zaposlen_z_jmbg unique (z_jmbg),
223 CONSTRAINT UQ_Zaposlen_z_email unique (z_email),
224 CONSTRAINT UQ_Zaposlen_z_broj unique (z_broj),
225 CONSTRAINT CH_Zaposlen_z_jmbg CHECK (len(z_jmbg) = 13),
226 CONSTRAINT CH_Zaposlen_z_datrodj CHECK (DATEDIFF(day, z_datrodj, CAST(current_timestamp as DATE)) > 0),
227 CONSTRAINT CH_Zaposlen_z_datum_zap_datrodj CHECK (DATEDIFF(day, z_datrodj, z_datum_zap) > 0),
228 CONSTRAINT CH_Zaposlen_z_datum_zap CHECK (DATEDIFF(day, z_datum_zap, CAST(current_timestamp as DATE)) > 0),
229 CONSTRAINT CK_Zaposlen_z_pol CHECK (z_pol in ('m', 'M', 'z', 'Z')),
230 CONSTRAINT FK_Zaposlen_Kandidat FOREIGN KEY (k_id)
231 references HR_Sluzba.Kandidat (k_id),
232 CONSTRAINT PK_Zaposlen_mbr_k_id PRIMARY KEY (mbr, k_id)
233);
234
235
236 CREATE TABLE [HR_Sluzba].[Evaluacioni_Test]
237 (
238 [id_evaluacionog_testa] NUMERIC(5),
239 [mbr] NUMERIC(13),
240 [k_id] NUMERIC(5),
241 [datum_testiranja] DATE NOT NULL,
242 CONSTRAINT FK_EVALUACIONI_TEST_ZAPOSLENI FOREIGN KEY(mbr,k_id)
243 REFERENCES [HR_Sluzba].[Zaposlen](mbr,k_id),
244 CONSTRAINT PK_EvALUACIONI_TEST PRIMARY KEY (id_evaluacionog_testa,mbr,k_id)
245 );
246 GO
247
248 ALTER TABLE [HR_Sluzba].[Evaluacioni_Test]
249 ADD CONSTRAINT DFT_ID_EVL_TEST DEFAULT(next value for [HR_Sluzba].[Evaluacioni_test_Sequence]) for id_evaluacionog_testa;
250
251
252 CREATE TABLE [HR_Sluzba].[Pripada]
253 (
254 [id_evaluacionog_testa] NUMERIC(5),
255 [mbr] NUMERIC(13),
256 [k_id] NUMERIC(5),
257 [id_tipa_evaluacionog_testa] NUMERIC(5),
258 CONSTRAINT FK_PRIPADA_EVALUACIONI_TEST FOREIGN KEY(id_evaluacionog_testa,mbr,k_id)
259 REFERENCES [HR_Sluzba].[Evaluacioni_Test](id_evaluacionog_testa,mbr,k_id),
260 CONSTRAINT FK_PRIPADA_TIP_TESTA FOREIGN KEY(id_tipa_evaluacionog_testa)
261 REFERENCES [HR_Sluzba].[Tip_evaluacionog_testa](id_tipa_evaluacionog_testa),
262 CONSTRAINT PK_PRIPADA PRIMARY KEY (id_evaluacionog_testa,mbr,k_id,id_tipa_evaluacionog_testa)
263 );
264 GO
265
266CREATE TABLE [HR_Sluzba].[Parametar_pripada]
267(
268 [rezultat_testa] NUMERIC(5) NOT NULL,
269 [id_parametra] NUMERIC(5),
270 [id_tipa_evaluacionog_testa] NUMERIC(5),
271 [id_evaluacionog_testa] NUMERIC(5),
272 [mbr] NUMERIC(13),
273 [k_id] NUMERIC(5),
274 [id_evaluacionog_tipa] NUMERIC(5),
275 CONSTRAINT FK_PARAMETAR_PRIPADA_PRIPADA FOREIGN KEY(id_evaluacionog_testa,mbr,k_id,id_tipa_evaluacionog_testa)
276 REFERENCES [HR_Sluzba].[Pripada](id_evaluacionog_testa,mbr,k_id,id_tipa_evaluacionog_testa),
277 CONSTRAINT FK_PARAMETAR_PRIPADA_IMA_PARAMETAR FOREIGN KEY(id_parametra,id_evaluacionog_tipa)
278 REFERENCES [HR_Sluzba].[Ima_Parametar](id_parametra,id_tipa_evaluacionog_testa),
279 CONSTRAINT PK_PARAMETAR_PRIPADA PRIMARY KEY(id_parametra,id_tipa_evaluacionog_testa,id_evaluacionog_testa,mbr,k_id,id_evaluacionog_tipa)
280);
281GO
282
283------------------------------------------------UPITI ZA UNOSENJE VREDNOSTI U TABELE------------------------------------------------
284
285/*DODAVANJE VREDNOSTI U TABELU KANDIDAT*/
286INSERT INTO HR_Sluzba.Kandidat (k_id,k_jmbg,k_ime,k_prezime,k_datrodj,k_pol,k_email,k_broj,k_drzv_stal,k_grad_stal,k_adres_stal,k_drzv_preb,k_grad_preb,k_adres_preb) VALUES
287 (next value for HR_Sluzba.Kandidat_Sequence,'5435444443326','Nikola','Nikolic','1997-01-30','M','nikolankolic1997@gmail.com','5354354543','Srbija','Pozarevac','B Stefana 8','Srbija','Novi Sad','B Slobode bb'),
288 (next value for HR_Sluzba.Kandidat_Sequence,'5435433333326','Marko','Markovic','1999-08-26','M','markomarkovi@hotmail.com','645454546','Srbija','Loznica','L Stevica 6','Srbija','Futog','NS put'),
289 (next value for HR_Sluzba.Kandidat_Sequence,'5435412345678','Milica','Milic','1987-04-20','Z','milicamilic@yahoo.com','132121321','Srbija','Loznica','Buliver Dositeja 1','Srbija','Beograd','Kneza Milosa 6'),
290 (next value for HR_Sluzba.Kandidat_Sequence,'8630660952838','Miloje','Antić','1952-02-02','M','milojeantic52@gmail.com','524702967','Srbija','Aranđelovac','Palih boraca 6','Srbija','Novi Sad','Moravska 11'),
291 (next value for HR_Sluzba.Kandidat_Sequence,'7415093640474','Irena','Ateljevic','1955-01-01','Z','irenaateljevic55@hotmail.com','072919278','BiH','Tuzla','Ustanicka 8','Srbija','Novi Sad','Negotinska 45'),
292 (next value for HR_Sluzba.Kandidat_Sequence,'4691326178273','Marina','Bogdanović','1959-08-20','Z','marinabogdanovic59@gmail.com','309190145','BiH','Zenica','Sarajevski put bb','Srbija','Beograd','Leposave Mihajlović 37'),
293 (next value for HR_Sluzba.Kandidat_Sequence,'5806924322452','Mihajlo','Stojanović','1960-05-18','M','mihajlostojanovic60@gmail.com','476755438','Srbija','Sombor','Svetog Save 26','Srbija','Beograd','Kirila Savića 82'),
294 (next value for HR_Sluzba.Kandidat_Sequence,'7487272113170','Mila','Kovac','1960-08-15','Z','milakovac1960@hotmail.com','780477190','Srbija','Ljubovija','Nemanjina 12','Srbija','Novi Sad','Olge Petrov 11'),
295 (next value for HR_Sluzba.Kandidat_Sequence,'8536316245751','Slavomir','Bogdanović','1961-02-06','M','slavomirbogdanovic61@gmail.com','203083681','BiH','Mostar','Lazinska 20','Srbija','Beograd','Junska bb'),
296 (next value for HR_Sluzba.Kandidat_Sequence,'8401148212423','Teodora','CrnÄević','1961-12-16','Z','teodoracrncevic61@hotmail.com','055556196','Hrvatska','Rijeka','Abramovićeva 14','Srbija','Beograd','Zorina 20'),
297 (next value for HR_Sluzba.Kandidat_Sequence,'6413779161048','Ivanka','Mihailović','1968-04-30','Z','ivankamihailovic68@hotmail.com','127888043','Hrvatska','Osjek','Alage 1','Srbija','Beograd','Emila Zole 26'),
298 (next value for HR_Sluzba.Kandidat_Sequence,'1567019236793','Momir','Petrović','1973-05-30','M','momirpetrovic73@yahoo.com','959544682','Srbija','Petrovac','Brace Jašić 28','Srbija','Novi Sad','Pionriska 1'),
299 (next value for HR_Sluzba.Kandidat_Sequence,'1363767701761','Jevrem','Janković','1973-09-23','M','jevremjankovic73@hotmail.com','586670382','Srbija','Niš','Bulevar Republike 4','Srbija','Beograd','Delijska 11'),
300 (next value for HR_Sluzba.Kandidat_Sequence,'4208537362437','Neno','Pavlović','1974-01-13','M','nenopavlovic74@hotmail.com','280870560','Hrvatska','Zadar','Alkarski put bb','Srbija','Beograd','Grahovska 6'),
301 (next value for HR_Sluzba.Kandidat_Sequence,'3188566586003','Mihajlo','Kovac','1975-04-28','M','mihajlokovac75@gmail.com','264990634','Srbija','Å abac','Proletejeva 63','Srbija','Novi Sad','Rataska bb'),
302 (next value for HR_Sluzba.Kandidat_Sequence,'4575495415321','Stanislava','Filipović','1977-12-19','Z','stanislavafilipovic77@hotmail.com','345194050','Hrvatska','Karlovac','Anićeva bb','Srbija','Novi Sad','Simonidina 32'),
303 (next value for HR_Sluzba.Kandidat_Sequence,'8056184826809','Dejana','Pavlović','1979-02-18','Z','dejanapavlovic79@hotmail.com','694410839','Hrvatska','Pula','Antoljaki 45','Srbija','Beograd','Viline Vode 4'),
304 (next value for HR_Sluzba.Kandidat_Sequence,'7500821294016','Dejana','Branković','1984-06-28','Z','dejanabrankovic84@gmail.com','893001021','Srbija','Kraljevo','Trg Ferdiha 23','Srbija','Novi Sad','Mornarska');
305
306/*DODAVANJE VREDNOSTI U TABELU ZAPOSLEN*/
307INSERT INTO HR_Sluzba.Zaposlen (k_id,mbr,z_jmbg,z_ime,z_prezime,z_datrodj,z_pol,z_email,z_broj,z_drzv_stal,z_grad_stal,z_adres_stal,z_drzv_preb,z_grad_preb,z_adres_preb,z_datum_zap) VALUES
308 (2,'6756045108644','5435433333326','Marko','Markovic','1999-08-26','M','markomarkovi@hotmail.com','645454546','Srbija','Loznica','L Stevica 6','Srbija','Futog','NS put','2004-10-27'),
309 (3,'6912051554350','5435412345678','Milica','Milic','1987-04-20','Z','milicamilic@yahoo.com','132121321','Srbija','Loznica','Buliver Dositeja 1','Srbija','Beograd','Kneza Milosa 6','2001-06-12'),
310 (4,'9801762982136','8630660952838','Miloje','Antić','1952-02-02','M','milojeantic52@gmail.com','524702967','Srbija','Aranđelovac','Palih boraca 6','Srbija','Novi Sad','Moravska 11','2004-11-11'),
311 (5,'3444534677142','7415093640474','Irena','Ateljevic','1955-01-01','Z','irenaateljevic55@hotmail.com','072919278','BiH','Tuzla','Ustanicka 8','Srbija','Novi Sad','Negotinska 45','2005-01-26'),
312 (6,'9768267793041','4691326178273','Marina','Bogdanović','1959-08-20','Z','marinabogdanovic59@gmail.com','309190145','BiH','Zenica','Sarajevski put bb','Srbija','Beograd','Leposave Mihajlović 37','2005-02-09'),
313 (8,'0582958504587','7487272113170','Mila','Kovac','1960-08-15','Z','milakovac1960@hotmail.com','780477190','Srbija','Ljubovija','Nemanjina 12','Srbija','Novi Sad','Olge Petrov 11','2005-07-04'),
314 (9,'7467674761963','8536316245751','Slavomir','Bogdanović','1961-02-06','M','slavomirbogdanovic61@gmail.com','203083681','BiH','Mostar','Lazinska 20','Srbija','Beograd','Junska bb','2007-06-04'),
315 (10,'1420399638411','8401148212423','Teodora','CrnÄević','1961-12-16','Z','teodoracrncevic61@hotmail.com','055556196','Hrvatska','Rijeka','Abramovićeva 14','Srbija','Beograd','Zorina 20','2008-07-16'),
316 (11,'2167270938438','6413779161048','Ivanka','Mihailović','1968-04-30','Z','ivankamihailovic68@hotmail.com','127888043','Hrvatska','Osjek','Alage 1','Srbija','Beograd','Emila Zole 26','2009-06-08'),
317 (12,'1392667994118','1567019236793','Momir','Petrović','1973-05-30','M','momirpetrovic73@yahoo.com','959544682','Srbija','Petrovac','Brace Jašić 28','Srbija','Novi Sad','Pionriska 1','2010-01-28'),
318 (13,'4709965354125','1363767701761','Jevrem','Janković','1973-09-23','M','jevremjankovic73@hotmail.com','586670382','Srbija','Niš','Bulevar Republike 4','Srbija','Beograd','Delijska 11','2010-04-08'),
319 (15,'6649441392640','3188566586003','Mihajlo','Kovac','1975-04-28','M','mihajlokovac75@gmail.com','264990634','Srbija','Å abac','Proletejeva 63','Srbija','Novi Sad','Rataska bb','2010-12-20'),
320 (16,'7092097107260','4575495415321','Stanislava','Filipović','1977-12-19','Z','stanislavafilipovic77@hotmail.com','345194050','Hrvatska','Karlovac','Anićeva bb','Srbija','Novi Sad','Simonidina 32','2015-09-01'),
321 (18,'8761567302511','7500821294016','Dejana','Branković','1984-06-28','Z','dejanabrankovic84@gmail.com','893001021','Srbija','Kraljevo','Trg Ferdiha 23','Srbija','Novi Sad','Mornarska','2018-11-21');
322
323
324/*DODAVANE VREDNOSTI U TABELU EVALUACIONI TEST*/
325INSERT INTO HR_Sluzba.Evaluacioni_Test (id_evaluacionog_testa,mbr,k_id,datum_testiranja) VALUES
326 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'6756045108644',2,'2015-06-26'),
327 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'6756045108644',2,'2015-10-19'),
328 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'6756045108644',2,'2015-12-31'),
329 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'6912051554350',3,'2016-02-08'),
330 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'6912051554350',3,'2016-03-22'),
331 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'9801762982136',4,'2016-04-07'),
332 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'3444534677142',5,'2016-05-05'),
333 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'3444534677142',5,'2016-11-16'),
334 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'3444534677142',5,'2016-12-01'),
335 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'3444534677142',5,'2017-01-18'),
336 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'9768267793041',6,'2017-01-26'),
337 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'0582958504587',8,'2017-05-23'),
338 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'7467674761963',9,'2017-09-26'),
339 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'1420399638411',10,'2017-10-03'),
340 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'2167270938438',11,'2017-10-04'),
341 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'2167270938438',11,'2017-12-21'),
342 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'2167270938438',11,'2018-03-02'),
343 (next value for HR_Sluzba.Evaluacioni_test_Sequence,'1392667994118',12,'2018-03-30');
344
345/*DODAVANJE VREDNOSTI U TABELU TIP EVALUACIONOG TESTA*/
346INSERT INTO HR_Sluzba.Tip_evaluacionog_testa (id_tipa_evaluacionog_testa,vrsta_testa) VALUES
347 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Test opste kulture'),
348 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Usmeno ispitivanje'),
349 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Prakticni test'),
350 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Psiholosko testiranje'),
351 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Zdrastveni test'),
352 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Strucni test - usmena forma'),
353 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Strucni test - pismena forma'),
354 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Test resavanja zadataka'),
355 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Rad u stresnim situacijima'),
356 (next value for HR_Sluzba.Tip_Evaluacionog_testa_Sequence,'Dopunsko testiranje');
357
358/*DODAVANE VREDNOSTI U TABELU PRIPADA*/
359
360INSERT INTO HR_Sluzba.Pripada (id_evaluacionog_testa,mbr,k_id,id_tipa_evaluacionog_testa) VALUES
361 ('0','6756045108644',2,'2'),
362 ('1','6756045108644',2,'3'),
363 ('2','6756045108644',2,'0'),
364 ('3','6912051554350',3,'8'),
365 ('4','6912051554350',3,'1'),
366 ('5','9801762982136',4,'2'),
367 ('6','3444534677142',5,'4'),
368 ('7','3444534677142',5,'9'),
369 ('8','3444534677142',5,'0'),
370 ('9','3444534677142',5,'2'),
371 ('10','9768267793041',6,'6'),
372 ('11','0582958504587',8,'7'),
373 ('12','7467674761963',9,'0'),
374 ('13','1420399638411',10,'9'),
375 ('14','2167270938438',11,'1'),
376 ('15','2167270938438',11,'2'),
377 ('16','2167270938438',11,'8'),
378 ('17','1392667994118',12,'4');
379
380/*DODAVANJE VREDNOSTI U TABELU PARAMETAR*/
381
382INSERT INTO HR_Sluzba.Parametar (id_parametra,kriterijum_evaluacije) VALUES
383 (next value for HR_Sluzba.Parametar_Sequence,'Opsta pismenost'),--0
384 (next value for HR_Sluzba.Parametar_Sequence,'Pozavanje politike'),--0
385 (next value for HR_Sluzba.Parametar_Sequence,'Poznavanje sporta'),--0
386 (next value for HR_Sluzba.Parametar_Sequence,'Poznavanje NUnita'),--1
387 (next value for HR_Sluzba.Parametar_Sequence,'Poznavanje Agilne metodologije'),--1
388 (next value for HR_Sluzba.Parametar_Sequence,'Poznavanje javascripta'),--2
389 (next value for HR_Sluzba.Parametar_Sequence,'Rad s REST tehnologijama'),--2
390 (next value for HR_Sluzba.Parametar_Sequence,'Procena vida'),--4
391 (next value for HR_Sluzba.Parametar_Sequence,'Procena sluha'),--4
392 (next value for HR_Sluzba.Parametar_Sequence,'Komunkacija'),--3
393 (next value for HR_Sluzba.Parametar_Sequence,'Rad u grupama'),--3
394 (next value for HR_Sluzba.Parametar_Sequence,'Rad s ogranicenim vremenom'),--8
395 (next value for HR_Sluzba.Parametar_Sequence,'Rad u zahtevnim situacijama');--8
396
397/*DODAVANJE VREDNOSTI U TABELU IMA PARAMETAR*/
398
399INSERT INTO HR_Sluzba.Ima_Parametar (id_parametra,id_tipa_evaluacionog_testa) VALUES
400 (0,0),--0
401 (1,0),--0
402 (2,0),--0
403 (3,1),--1
404 (4,1),--1
405 (5,2),--2
406 (6,2),--2
407 (7,4),--4
408 (8,4),--4
409 (9,3),--3
410 (10,3),--3
411 (11,8),--8
412 (12,8);--8
413
414/*DODAVANJE VREDNOSTI U TABELU PARAMETAR PRIPADA*/
415INSERT INTO HR_Sluzba.Parametar_pripada (rezultat_testa,id_parametra,id_tipa_evaluacionog_testa,id_evaluacionog_testa,mbr,k_id,id_evaluacionog_tipa) VALUES
416 (8,0,0,2,'6756045108644',2,0),
417 (7,1,0,8,'3444534677142',5,0),
418 (8,2,0,12,'7467674761963',9,0),
419 (9,3,1,4,'6912051554350',3,1),
420 (8,4,1,14,'2167270938438',11,1),
421 (10,5,2,5,'9801762982136',4,2),
422 (9,6,2,15,'2167270938438',11,2),
423 (8,7,4,6,'3444534677142',5,4),
424 (10,8,4,17,'1392667994118',12,4),
425 (9,9,3,1,'6756045108644',2,3),
426 (7,10,3,1,'6756045108644',2,3),
427 (9,11,8,3,'6912051554350',3,8),
428 (8,12,8,16,'2167270938438',11,8);