group:Firma Klijent = { SifK:number, Naziv:string, Kontakt:string 1, 'Klijent1', '06411234111' 2, 'Klijent2', '06411234112' 3, 'Klijent3', '06411234113' 4, 'Klijent4', '06411234114' 5, 'Klijent5', '06411234115' 6, 'Klijent6', '06411234116' } Radnik = { SifR:number, Ime:string 1, 'Radnik1' 2, 'Radnik2' 3, 'Radnik3' 4, 'Radnik4' 5, 'Radnik5' 6, 'Radnik6' 7, 'Radnik7' 8, 'Radnik8' 9, 'Radnik9' 10, 'Radnik10' 11, 'Radnik11' 12, 'Radnik12' } Menadzer = { SifR:number, Iskustvo:number 1, 10 2, 7 3, 6 4, 15 } Programer = { SifR:number, Specijalnost:string 5, 'Java' 6, 'Java' 7, 'C' 8, 'C' 9, 'Java' 10, 'Java' 11, 'C' 12, 'C' } Projekat = { SifP:number, Naziv:string, Status:string, Vrednost:number, DatumPocetka:string, BrProgramerDana:number, MaksProgramera:number, SifK:number, SifR:number 1, 'ETF', 'I', 15000, '2020-05-06', 100, 10, 1, 1 2, 'P2', 'I', 12000, '2020-05-06', 100, 10, 2, 1 3, 'P3', 'I', 18000, '2020-07-06', 150, 8, 3, 1 4, 'P4', 'I', 15000, '2020-04-06', 120, 10, 2, 2 5, 'P5', 'I', 5000, '2020-01-06', 130, 10, 3, 2 6, 'P6', 'P', 15000, '2020-05-26', 100, 10, 2, 3 7, 'P7', 'Z', 12000, '2020-05-16', 100, 10, 3, 4 } Zahtev = { SifZ:number, Opis:string, SifP:number 1, 'P1Z1', 1 2, 'P1Z2', 1 3, 'P1Z3', 1 4, 'P2Z1', 2 5, 'P2Z2', 2 6, 'P3Z1', 3 7, 'P4Z1', 4 8, 'P5Z1', 5 9, 'P6Z1', 6 10, 'P7Z1', 7 } Posao = { SifJ:number, DatumPocetka:string, DatumKraja:string, BrPlaniranihProgramera:number, SifP:number, SifZ:number 1, '2020-10-01', '2021-02-02', 3, 1, 1 2, '2020-11-01', '2021-02-07', 3, 1, 2 3, '2020-07-02', '2021-02-05', 3, 1, 3 4, '2020-11-05', '2021-02-05', 3, 2, 4 5, '2020-10-01', '2021-01-02', 3, 2, 5 6, '2020-12-06', '2021-11-02', 3, 3, 6 7, '2020-10-04', '2021-12-02', 3, 4, 7 8, '2020-12-02', '2021-06-02', 2, 5, 8 9, '2020-10-01', '2021-03-02', 1, 6, 9 10, '2020-10-08', '2021-05-02', 1, 7, 10 } Angazman = { SifA:number, SifR:number, SifJ:number 1, 5, 1 2, 6, 1 3, 7, 1 4, 5, 2 5, 7, 2 6, 8, 2 7, 5, 3 8, 7, 3 9, 9, 3 10, 5, 4 11, 7, 4 12, 8, 5 13, 9, 5 14, 7, 6 15, 7, 7 16, 5, 8 17, 7, 9 18, 5, 10 } Kod = { SifK:number, Kod:string 1, 'Kod1' 2, 'Kod2' 3, 'Kod3' } Implementira = { SifK:number, SifZ:number 1, 5 2, 6 3, 7 }