{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"kKNY8SZkID\"><a href=\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\">\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/embed\/#?secret=kKNY8SZkID\" width=\"600\" height=\"338\" title=\"&#8220;\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"kKNY8SZkID\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"\u0130li\u015fkisel veritabanlar\u0131, verileri tablolar halinde d\u00fczenleyerek ve bu tablolar aras\u0131nda ili\u015fkiler kurarak \u00e7al\u0131\u015f\u0131r. Bu ili\u015fkileri sa\u011flayan en \u00f6nemli kavramlar ise birincil anahtarlar (primary keys) ve yabanc\u0131 anahtarlard\u0131r (foreign keys). \u00d6ncelikle, bu iki anahtar t\u00fcr\u00fcn\u00fc ayr\u0131nt\u0131l\u0131 olarak inceleyelim. Bu kavramlar\u0131 anlamak, veritaban\u0131 tasar\u0131m\u0131nda verimlili\u011fi ve tutarl\u0131l\u0131\u011f\u0131 sa\u011flamak i\u00e7in son derece \u00f6nemlidir."}