{"id":992,"date":"2020-05-13T23:35:58","date_gmt":"2020-05-13T21:35:58","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=992"},"modified":"2020-05-29T14:32:29","modified_gmt":"2020-05-29T12:32:29","slug":"kreiranje-veza","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=992","title":{"rendered":"Kreiranje veza"},"content":{"rendered":"<p>Da bi se izvr\u0161ilo povezivanje tabela u bazi podataka, potrebno je iz <strong>Ribbon<\/strong> palete izabrati tab <strong>DatabaseTools<\/strong>, pa <strong>Relationships<\/strong>. Tada \u0107e se otvoriti prozor koji je prikazan na slede\u0107oj slici (Slika 1), kao i tab Design.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-999\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza361.jpg\" alt=\"kreiranjeveza361\" width=\"378\" height=\"390\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza361.jpg 378w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza361-291x300.jpg 291w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><br \/>\n<em>Slika 1<\/em><\/p>\n<h2><a name=\"_Toc384656579\"><\/a>Dodavanje tabela u Relationships prozor<\/h2>\n<p>Prostor rezervisan za kreiranje veza izme\u0111u tabela je trenutno prazan, jer jo\u0161 uvek nisu definisane veze. Potrebno je dodati tabele i povezati ih. Dodavanje tabela vr\u0161i se njihovim prevla\u010denjem ili desnim klikom mi\u0161a na prazan prostor otvoriti meni iz kojeg je potrebno izabrati <strong>Show Table<\/strong>, a zatim dodati \u017eeljene tabele. Nakon \u0161to dodamo sve tabele, Relationships prozor izgleda kao na slede\u0107oj slici (Slika 2).<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1000\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza362.jpg\" alt=\"kreiranjeveza362\" width=\"935\" height=\"183\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza362.jpg 935w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza362-300x59.jpg 300w\" sizes=\"auto, (max-width: 935px) 100vw, 935px\" \/><br \/>\n<em>Slika 2<\/em><\/p>\n<h2><a name=\"_Toc384656580\"><\/a>Povezivanje tabela &#8211; jak i slab entitet, spoljni klju\u010d, agregacija, unarna veza<\/h2>\n<p>Sada je potrebno povezati odgovaraju\u0107e tabele. Tabela <strong>U\u010denici<\/strong> i <strong>Mesto<\/strong> imaju povezuju\u0107e polje mesto, odnosno <strong>IDmesta<\/strong>. Atribut mesto u tabeli U\u010denici predstavlja spoljni klju\u010d, dok je IDmesta u tabeli Mesto on primarni klju\u010d. Ove tabele se povezuju tako \u0161to se primarni klju\u010d tabele Mesto mi\u0161em prevla\u010di na spoljni klju\u010d Mesto tabele U\u010denici. Kada se otpusti taster mi\u0161a, otvori\u0107e se prozor prikazan na slede\u0107oj slici (Slika 3).<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1001\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza363.jpg\" alt=\"kreiranjeveza363\" width=\"367\" height=\"262\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza363.jpg 367w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza363-300x214.jpg 300w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2016\/04\/kreiranjeveza363-120x85.jpg 120w\" sizes=\"auto, (max-width: 367px) 100vw, 367px\" \/><br \/>\n<em>Slika 3<\/em><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"Da bi se izvr\u0161ilo povezivanje tabela u bazi podataka, potrebno je iz<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=992\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":1002,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-992","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-access"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=992"}],"version-history":[{"count":1,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/992\/revisions"}],"predecessor-version":[{"id":1216,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/992\/revisions\/1216"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/1002"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}