{"id":15234,"date":"2025-03-15T10:15:17","date_gmt":"2025-03-15T07:15:17","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/"},"modified":"2025-03-15T10:15:17","modified_gmt":"2025-03-15T07:15:17","slug":"iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/","title":{"rendered":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar"},"content":{"rendered":"<p><body><\/p>\n<p>\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar<\/p>\n<p>\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.<\/p>\n<h2>Birincil Anahtar (Primary Key): Verinin Benzersiz Kimli\u011fi<\/h2>\n<p>Bir birincil anahtar, bir veritaban\u0131 tablosundaki her sat\u0131r\u0131 benzersiz bir \u015fekilde tan\u0131mlayan bir s\u00fct\u00fcnd\u00fcr.  Ba\u015fka bir deyi\u015fle, bir tablodaki her sat\u0131r\u0131n kendine \u00f6zg\u00fc bir kimlik numaras\u0131 gibi d\u00fc\u015f\u00fcnebiliriz.  Bu s\u00fctun ayn\u0131 de\u011fere sahip iki sat\u0131r i\u00e7eremez.  \u00d6rne\u011fin, bir &#8220;m\u00fc\u015fteriler&#8221; tablosunda, m\u00fc\u015fteri kimlik numaras\u0131 (m\u00fc\u015fteri_id) birincil anahtar olarak kullan\u0131labilir. Her m\u00fc\u015fterinin farkl\u0131 bir m\u00fc\u015fteri_id numaras\u0131 olacak ve bu numara tekrar etmeyecektir. Bu sayede, her bir m\u00fc\u015fteriyi benzersiz bir \u015fekilde tan\u0131mlayabiliriz.  Birincil anahtar\u0131n veritaban\u0131 i\u00e7indeki \u00f6nemi olduk\u00e7a b\u00fcy\u00fckt\u00fcr; \u00e7\u00fcnk\u00fc verileri h\u0131zl\u0131 ve kolay bir \u015fekilde aramak ve g\u00fcncellemek i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p>Birincil anahtar\u0131n baz\u0131 \u00f6zellikleri \u015funlard\u0131r:<\/p>\n<ul>\n<li><b>Benzersiz de\u011ferler:<\/b> Her sat\u0131r i\u00e7in farkl\u0131 bir de\u011fer i\u00e7ermelidir.<\/li>\n<li><b>NULL de\u011feri i\u00e7ermemelidir:<\/b>  Bo\u015f de\u011fer kabul etmez. Her sat\u0131rda bir de\u011fer bulunmal\u0131d\u0131r.<\/li>\n<li><b>Verimli indeksleme:<\/b> Veritaban\u0131 y\u00f6netim sistemleri (DBMS), birincil anahtar \u00fczerinde otomatik indeks olu\u015fturarak verilerin h\u0131zl\u0131 bir \u015fekilde aranmas\u0131n\u0131 sa\u011flar.<\/li>\n<\/ul>\n<h2>Yabanc\u0131 Anahtar (Foreign Key): Tablolar Aras\u0131 \u0130li\u015fki<\/h2>\n<p>Yabanc\u0131 anahtarlar ise farkl\u0131 tablolar aras\u0131ndaki ili\u015fkileri kurmak i\u00e7in kullan\u0131l\u0131r.  Bir tablodaki yabanc\u0131 anahtar, ba\u015fka bir tablodaki birincil anahtara referans g\u00f6sterir.  \u00d6rne\u011fin, bir &#8220;sipari\u015fler&#8221; tablosunda &#8220;m\u00fc\u015fteri_id&#8221; s\u00fctunu bir yabanc\u0131 anahtar olabilir. Bu s\u00fctun, &#8220;m\u00fc\u015fteriler&#8221; tablosundaki &#8220;m\u00fc\u015fteri_id&#8221; birincil anahtar\u0131na referans verir.  Bu sayede, her sipari\u015fin hangi m\u00fc\u015fteriye ait oldu\u011funu kolayca belirleyebiliriz.  Yabanc\u0131 anahtarlar, veritaban\u0131nda veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamada kritik rol oynar.  \u00d6rne\u011fin, bir sipari\u015f kayd\u0131 olu\u015ftururken, ilgili m\u00fc\u015fterinin &#8220;m\u00fc\u015fteriler&#8221; tablosunda var oldu\u011fundan emin olmak i\u00e7in yabanc\u0131 anahtar kontrol\u00fc yap\u0131l\u0131r.<\/p>\n<p>Yabanc\u0131 anahtarlar\u0131n kullan\u0131m\u0131n\u0131n bir\u00e7ok avantaj\u0131 vard\u0131r: <\/p>\n<ul>\n<li><b>Veri b\u00fct\u00fcnl\u00fc\u011f\u00fc:<\/b> \u0130li\u015fkili verilerin tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flar.<\/li>\n<li><b>Veri fazlal\u0131\u011f\u0131n\u0131 azalt\u0131r:<\/b> Ayn\u0131 bilgilerin farkl\u0131 tablolar da tekrar tekrar saklanmas\u0131n\u0131 \u00f6nler.<\/li>\n<li><b>Veri ili\u015fkilerini belirler:<\/b> Tablolar aras\u0131nda mant\u0131ksal ba\u011flant\u0131 kurar.<\/li>\n<\/ul>\n<h2>\u00d6rnek Senaryo<\/h2>\n<p>\u015eimdi, bir \u00f6rnek ile konuyu daha iyi anlamaya \u00e7al\u0131\u015fal\u0131m. Diyelim ki bir e-ticaret sitesi i\u00e7in bir veritaban\u0131 tasarl\u0131yoruz. \u0130ki tablomuz olsun:  &#8220;\u00dcr\u00fcnler&#8221; ve &#8220;Sipari\u015fler&#8221;.<\/p>\n<p>&#8220;\u00dcr\u00fcnler&#8221; tablosunda birincil anahtar\u0131m\u0131z &#8220;\u00fcr\u00fcn_id&#8221; olsun. &#8220;Sipari\u015fler&#8221; tablosunda ise &#8220;siparis_id&#8221; birincil anahtar, &#8220;\u00fcr\u00fcn_id&#8221; ise &#8220;\u00dcr\u00fcnler&#8221; tablosuna referans g\u00f6steren bir yabanc\u0131 anahtard\u0131r. Bu sayede her sipari\u015fin hangi \u00fcr\u00fcne ait oldu\u011funu kolayca takip edebiliriz.<\/p>\n<p><code><br \/>\n  -- \u00dcr\u00fcnler Tablosu<br \/>\n  CREATE TABLE \u00dcr\u00fcnler (<br \/>\n    \u00fcr\u00fcn_id INT PRIMARY KEY,<br \/>\n    \u00fcr\u00fcn_ad\u0131 VARCHAR(255),<br \/>\n    fiyat DECIMAL(10,2)<br \/>\n  );<\/p>\n<p>  -- Sipari\u015fler Tablosu<br \/>\n  CREATE TABLE Sipari\u015fler (<br \/>\n    siparis_id INT PRIMARY KEY,<br \/>\n    \u00fcr\u00fcn_id INT,<br \/>\n    miktar INT,<br \/>\n    FOREIGN KEY (\u00fcr\u00fcn_id) REFERENCES \u00dcr\u00fcnler(\u00fcr\u00fcn_id)<br \/>\n  );<br \/>\n<\/code><\/p>\n<p>Bu \u00f6rnekte, &#8220;Sipari\u015fler&#8221; tablosundaki &#8220;\u00fcr\u00fcn_id&#8221; s\u00fctunu, &#8220;\u00dcr\u00fcnler&#8221; tablosundaki &#8220;\u00fcr\u00fcn_id&#8221; s\u00fctununa yabanc\u0131 anahtard\u0131r. Bu sayede, bir sipari\u015f kayd\u0131 olu\u015fturuldu\u011funda,  &#8220;\u00fcr\u00fcn_id&#8221; nin &#8220;\u00dcr\u00fcnler&#8221; tablosunda var olan bir \u00fcr\u00fcn_id&#8217;ye kar\u015f\u0131l\u0131k geldi\u011finden emin oluruz.<\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>\u00d6zetle, birincil anahtarlar ve yabanc\u0131 anahtarlar, ili\u015fkisel veritabanlar\u0131n\u0131n temel ta\u015flar\u0131d\u0131r.  Veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak, verimlili\u011fi art\u0131rmak ve ili\u015fkili verileri y\u00f6netmek i\u00e7in olmazsa olmaz unsurlard\u0131r.  Bu kavramlar\u0131 iyi anlamak, veritaban\u0131 tasar\u0131m\u0131nda b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r.  Daha fazla bilgi i\u00e7in <a href=\"https:\/\/fatihsoysal.com\">fatihsoysal.com<\/a> sitesini ziyaret edebilirsiniz.  Ayr\u0131ca, SQL \u00f6\u011frenmek i\u00e7in bir\u00e7ok faydal\u0131 kaynak mevcuttur. Ba\u015flang\u0131\u00e7 i\u00e7in <a href=\"https:\/\/www.w3schools.com\/sql\/\">W3Schools SQL E\u011fitimi<\/a>  faydal\u0131 olacakt\u0131r.<\/p>\n<p>#Etiketler: ili\u015fkisel veritaban\u0131, birincil anahtar, yabanc\u0131 anahtar, primary key, foreign key, veritaban\u0131 tasar\u0131m\u0131, SQL, database, veri b\u00fct\u00fcnl\u00fc\u011f\u00fc,  fatihsoysal.com<\/p>\n<p><\/body><br \/>\n<\/html><\/p>\n","protected":false},"excerpt":{"rendered":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar \u0130li\u015fkisel veritabanlar\u0131, verileri tablolar halinde d\u00fczenleyerek ve bu tablolar aras\u0131nda ili\u015fkiler&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-15234","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar<\/title>\n<meta name=\"description\" content=\"\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.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar\" \/>\n<meta property=\"og:description\" content=\"\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.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-15T07:15:17+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar\",\"datePublished\":\"2025-03-15T07:15:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\"},\"wordCount\":691,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\",\"name\":\"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-03-15T07:15:17+00:00\",\"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.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar","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.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/","og_locale":"tr_TR","og_type":"article","og_title":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar","og_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.","og_url":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-03-15T07:15:17+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar","datePublished":"2025-03-15T07:15:17+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/"},"wordCount":691,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/","url":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/","name":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-03-15T07:15:17+00:00","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.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/iliskisel-veritabanlarinin-temelleri-anahtarlar-ve-yabanci-anahtarlar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0130li\u015fkisel Veritabanlar\u0131n\u0131n Temelleri: Anahtarlar ve Yabanc\u0131 Anahtarlar"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/15234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=15234"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/15234\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=15234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=15234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=15234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}