{"id":1464,"date":"2021-03-22T19:47:08","date_gmt":"2021-03-22T18:47:08","guid":{"rendered":"https:\/\/ssntb.org\/mirozaric\/?p=1464"},"modified":"2021-03-22T19:47:08","modified_gmt":"2021-03-22T18:47:08","slug":"kreiranje-relacija","status":"publish","type":"post","link":"https:\/\/ssntb.org\/mirozaric\/2021\/03\/22\/kreiranje-relacija\/","title":{"rendered":"Kreiranje relacija"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u2022Nakon kreiranja potrebnih tabela prelazimo na slede\u0107i korak, a to je uspostavljanje veza me\u0111u tabelama, ta\u010dnije me\u0111u poljima iz tabela preko kojih su one povezane. Da bi smo to uradili biramo tab (karticu) Database Tools, a zatim Relationships. Slede\u0107i korak je da odaberemo tabele koje treba povezati, a nakon toga pomo\u0107u mi\u0161a tehnikom prevla\u010denja \u0107emo uspostaviti vezu. Za donju sliku aktivnost je bila slede\u0107a \u2013 postaviti pokaziva\u010d mi\u0161a nad polje SBROJ u tabeli SEKTOR, a zatim prevu\u0107i do polja S_BROJ u tabeli RADNIK. Otpustiti taster mi\u0161a. U malom prozoru koji se pojavi treba \u010dekirati opciju Enforce Referential Integrity. Pojavi\u0107e se grafi\u010dki prikaz veze na kojoj je ozna\u010dena i funkcionalnost: 1 na strani SEKTOR, a \u221e (\u0161to zna\u010di N) na strani RADNIK.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"724\" height=\"601\" src=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/03\/image-33.png\" alt=\"\" class=\"wp-image-1465\" srcset=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/03\/image-33.png 724w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/03\/image-33-300x249.png 300w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Po\u0161to smo uspostavili Referential Integrity ne\u0107e biti mogu\u0107e napraviti gre\u0161ku slede\u0107e vrste \u2013 da unosimo podatke za radnika i da mu u polje S_BROJ upi\u0161emo vrijednost koja ne postoji ve\u0107 unijeta u tabelu SEKTOR. Zna\u010di ne mora vi\u0161e programer da se brine o tome kao nekada kada su se aplikacije za baze podataka pisale u npr Clipper \u2013u. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tako\u0111e programer ne mora vi\u0161e da misli o indeksima (mehanizam koji omogu\u0107ava znatno br\u017ei rad sa tabelama podataka) i njihovoj ispravnosti niti o silnim DBF (tabele, data base file) fajlovima, po\u0161to je u Access\u2013u sve to objedinjeno \u2013 \u010ditava baza sa svim svojim tabelama, indeksima, upitima itd je sada u samo jednom fajlu na disku.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u2022Nakon kreiranja potrebnih tabela prelazimo na slede\u0107i korak, a to je uspostavljanje veza me\u0111u tabelama, ta\u010dnije me\u0111u poljima iz tabela preko kojih su one povezane. Da bi smo to uradili biramo tab (karticu) Database Tools, a zatim Relationships. Slede\u0107i korak je da odaberemo tabele koje treba povezati, a nakon toga pomo\u0107u mi\u0161a tehnikom prevla\u010denja \u0107emo&hellip; <br \/> <a class=\"button small blue\" href=\"https:\/\/ssntb.org\/mirozaric\/2021\/03\/22\/kreiranje-relacija\/\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1464","post","type-post","status-publish","format-standard","hentry","category-18"],"_links":{"self":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/comments?post=1464"}],"version-history":[{"count":1,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1464\/revisions"}],"predecessor-version":[{"id":1466,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1464\/revisions\/1466"}],"wp:attachment":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/media?parent=1464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/categories?post=1464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/tags?post=1464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}