{"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":"Pk ve Fk: Veri Taban\u0131 Anahtarlar\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"64Jh5Ol4tC\"><a href=\"https:\/\/fatihsoysal.com\/blog\/pk-ve-fk-veri-tabani-anahtarlarinin-karsilastirilmasi\/\">Pk ve Fk: Veri Taban\u0131 Anahtarlar\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/pk-ve-fk-veri-tabani-anahtarlarinin-karsilastirilmasi\/embed\/#?secret=64Jh5Ol4tC\" width=\"600\" height=\"338\" title=\"&#8220;Pk ve Fk: Veri Taban\u0131 Anahtarlar\u0131n\u0131n Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"64Jh5Ol4tC\" 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":"Veri tabanlar\u0131 ile \u00e7al\u0131\u015fan herkesin mutlaka kar\u015f\u0131la\u015ft\u0131\u011f\u0131 iki temel kavram \"birincil anahtar\" (PK - Primary Key) ve \"yabanc\u0131 anahtar\" (FK - Foreign Key)'dir. Bu makalede, PK ve FK'n\u0131n ne oldu\u011funu, nas\u0131l \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131, farkl\u0131l\u0131klar\u0131n\u0131 ve kullan\u0131m senaryolar\u0131n\u0131 detayl\u0131 olarak ele alaca\u011f\u0131z. Ayr\u0131ca, verimli ve g\u00fcvenli veri tabanlar\u0131 tasar\u0131m\u0131 i\u00e7in bu anahtar t\u00fcrlerini nas\u0131l etkili bir \u015fekilde kullanabilece\u011finizi ad\u0131m ad\u0131m g\u00f6sterece\u011fiz. PK ve FK'n\u0131n do\u011fru kullan\u0131m\u0131, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak ve veritaban\u0131 performans\u0131n\u0131 optimize etmek a\u00e7\u0131s\u0131ndan kritik \u00f6neme sahiptir."}