Kod SQL za kreiranje tabela
create table deonica
(
iddeonica int not null,
duzina real,
Vn real,
tip_voda int,
presek real,
Rd real,
Ri real,
Ro real,
Xd real,
Xi real,
Xo real,
Bd real,
Bi real,
Bo real,
Gd real,
Gi real,
Go real,
pocetak int,
kraj int,
constraint deonica_pk primary key (iddeonica)
)
create table sabirnica
(
idsabirnica int not null,
Vn real,
idcvora int
constraint sabirnica_pk primary key (idsabirnica)
)
create table potrosac
(
idpotrosaca int not null,
tip int,
Vn real,
S real,
maksigraf real,
dijagram real,
idcvora int,
constraint potrosac_pk primary key (idpotrosaca)
)
create table transformator_s
(
idtrans_s int not null,
S real,
Vp real,
Vs real,
uk12 real,
Pcu real,
Pfe real,
Jfe real,
idcvora int
constraint idtrans_s_pk primary key (idtrans_S)
)
create table transformator_V
(
idtrans_v int not null,
Sp real,
Ss real,
St real,
Vp real,
Vs real,
Vt real,
Pcups real,
Pcupt real,
Pcust real,
Pfe real,
Jfe real,
uk12 real,
uk13 real,
uk23 real,
idcvora int,
constraint idtrans_v_pk primary key (idtrans_v)
)
create table rasklopna_oprema
(
idoprema int not null,
Vn real,
tip_opreme int,
idcvora int,
constraint sklp_opr_pk primary key (idoprema)
)
Kod za popunjavanje gore kreirane Tabele
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4001,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5001)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4002,2,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5001,5002)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4003,2.5,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5002,5007)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4004,2,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5003)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4005,3,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5003,5004)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4006,3,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5004,5007)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4007,2.5,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,2001,5005)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4008,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5005,5006)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4009,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5006,5007)
insert into deonica (iddeonica,duzina,Vn,tip_voda,presek,Rd,Ri,Ro,Xd,Xi,Xo,Bd,Bi,Bo,Gd,Gi,Go,pocetak,kraj)
values (4010,1,20,2,null,0.209,0.209,0.75,0.117,0.117,0.112,0.116,0.116,0.695,0,0,0,5005,5004)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (1,20,2001)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (2,20,2001)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (3,20,5001)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (4,0.4,5001)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (5,20,5002)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (6,0.4,5002)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (7,20,5003)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (8,0.4,5003)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (9,20,5004)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (10,0.4,5004)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (11,20,5005)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (12,0.4,5005)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (13,20,5006)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (14,0.4,5006)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (15,20,5007)
insert into sabirnica (idsabirnica,Vn,idcvora)
values (16,0.4,5007)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (1,2,0.4,null,null,null,5001)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (2,2,0.4,null,null,null,5002)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (3,1,0.4,null,null,null,5003)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (4,1,0.4,null,null,null,5004)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (5,2,0.4,null,null,null,5005)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (6,2,0.4,null,null,null,5006)
insert into potrosac(idpotrosaca,tip,Vn,S,maksigraf,dijagram,idcvora)
values (7,1,0.4,null,null,null,5007)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6001,1000,20,0.4,5,8.55,2.2,0.8,5001)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6002,1000,20,0.4,5,8.55,2.2,0.8,5001)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6003,1000,20,0.4,5,8.55,2.2,0.8,5002)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6004,1000,20,0.4,5,8.55,2.2,0.8,5003)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6005,1000,20,0.4,5,8.55,2.2,0.8,5003)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6006,1000,20,0.4,5,8.55,2.2,0.8,5003)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6007,1000,20,0.4,5,8.55,2.2,0.8,5003)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6008,1000,20,0.4,5,8.55,2.2,0.8,5004)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6009,1000,20,0.4,5,8.55,2.2,0.8,5004)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6010,1000,20,0.4,5,8.55,2.2,0.8,5005)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6011,1000,20,0.4,5,8.55,2.2,0.8,5006)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6012,1000,20,0.4,5,8.55,2.2,0.8,5007)
insert into transformator_s (idtrans_s,S,Vp,Vs,uk12,Pcu,Pfe,Jfe,idcvora)
values (6013,1000,20,0.4,5,8.55,2.2,0.8,5007)
insert into transformator_v (idtrans_v,Sp,Ss,St,Vp,Vs,Vt,Pcups,Pcupt,Pcust,Pfe,Jfe,uk12,uk13,uk23,idcvora)
values (3001,31500,31500,10500,110,20,10,131,0,0,40,0.4,12.7,9.19,2.4,2001)
insert into transformator_v (idtrans_v,Sp,Ss,St,Vp,Vs,Vt,Pcups,Pcupt,Pcust,Pfe,Jfe,uk12,uk13,uk23,idcvora)
values (3002,31500,31500,10500,110,20,10,131,0,0,40,0.4,12.7,9.19,2.4,2001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (1,20,1,2001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (2,20,1,2001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (3,20,1,2001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (4,20,1,2001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (5,20,2,5001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (6,20,2,5001)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (7,20,2,5002)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (8,20,2,5002)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (9,20,2,5003)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (10,20,2,5003)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (11,20,2,5004)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (12,20,2,5004)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (13,20,2,5004)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (14,20,2,5007)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (15,20,2,5007)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (16,20,2,5007)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (17,20,2,5005)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (18,20,2,5005)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (19,20,2,5005)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (20,20,2,5006)
insert into rasklopna_oprema (idoprema,Vn,tip_opreme,idcvora)
values (21,20,2,5006)
E sad moj zadatak je skoro celi da napravim ovo sto sam napravio. I to funkcionise. Ja sada treba da jos napisem kod u C++ koji na osnovu unetog ID deonice (Na osnovu deonice treba da odredim prvo spojno polje, tacnije pocetak ). Ako neko moze da pomogne bio bi mu zahvalan moram to do prekosutra da zavrsim. Ja bi znao da je cist C++ ali ne znam kako da poveze ovu tabelu .
Hvala svima