{"id":179576,"date":"2024-05-13T20:31:51","date_gmt":"2024-05-13T19:31:51","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=179576"},"modified":"2024-02-23T13:58:52","modified_gmt":"2024-02-23T12:58:52","slug":"unlocking-the-power-of-sql-foreign-keys-definition-and-applications","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications","title":{"rendered":"Unlocking the Power of SQL Foreign Keys: Definition and Applications"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"179576\" class=\"elementor elementor-179576\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e8b7b26 e-flex e-con-boxed e-con\" data-id=\"e8b7b26\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5bb83fc elementor-widget elementor-widget-heading\" data-id=\"5bb83fc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">If you're designing an SQL database management system, it's in your interest to know and implement the foreign key system. In the long term, it's a win-win situation.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-838388f elementor-widget elementor-widget-text-editor\" data-id=\"838388f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>A foreign key is a column (or several columns) in a <a href=\"https:\/\/datascientest.com\/en\/olap-everything-you-need-to-know-about-this-database-organization\">database<\/a> that is linked to the primary key column of another table. The primary key in question is a simple identifier. The useful information &#8211; which is subject to change &#8211; is contained in the external table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6548147 e-flex e-con-boxed e-con\" data-id=\"6548147\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2895786 elementor-widget elementor-widget-heading\" data-id=\"2895786\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What use is a foreign key?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-776daad elementor-widget elementor-widget-text-editor\" data-id=\"776daad\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Let&#8217;s imagine you&#8217;re managing an <strong>Articles table,<\/strong> in which there&#8217;s a column called Category. For each item, this category must be filled in individually.<\/p><p>For example, we might have a category called &#8220;Metal product&#8221;. However, from one day to the next, legislation changes and this category becomes<strong> &#8220;Metal-based product&#8221;.<\/strong><\/p><p>What do we do now? Will we have to modify all the lines in which the &#8220;Metal product&#8221; category appears? Unfortunately, yes. If the Articles table covers tens of thousands of entries, the procedure will be tedious, to say the least.<\/p><p>It&#8217;s to avoid this kind of situation that the notion of foreign key has been defined. So, in the case mentioned above, the idea is to create a separate table, called Category, in which the primary key is an identifier (a number for each category) associated with the corresponding description.<\/p><p>From there, in the <strong>Articles table,<\/strong> all we need to do is indicate, for each product offered in the catalog, the corresponding identifier from the Categories table.<\/p><p>It will then be possible to print the list of each item while displaying (thanks to a join) the corresponding category.<\/p><p>So, as we can see, the situation of the category that changes its name is solved here.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-98ad6b9 e-flex e-con-boxed e-con\" data-id=\"98ad6b9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-934de81 elementor-widget elementor-widget-heading\" data-id=\"934de81\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Parent and daughter table<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c511434 elementor-widget elementor-widget-text-editor\" data-id=\"c511434\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A &#8220;parent table&#8221; is one that is referenced by another table. This would be the case here of the <strong>Categories table.<\/strong><\/p><p>And we speak of a &#8220;daughter table&#8221; for one that refers to an external table &#8211; which would be the case here of the Articles table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6cc1df2 e-flex e-con-boxed e-con\" data-id=\"6cc1df2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5499b2 elementor-widget elementor-widget-heading\" data-id=\"e5499b2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">A practical example<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85951dc elementor-widget elementor-widget-text-editor\" data-id=\"85951dc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here&#8217;s another example of the use of a foreign key in a more explicit case.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-00a7bcc elementor-widget elementor-widget-heading\" data-id=\"00a7bcc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">CLIENTS table<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f9fbe1 elementor-widget elementor-widget-html\" data-id=\"8f9fbe1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-97aw{font-family:\"Trebuchet MS\", Helvetica, sans-serif !important;font-size:16px;text-align:center;vertical-align:top}\r\n.tg .tg-lyi1{font-family:\"Trebuchet MS\", Helvetica, sans-serif !important;font-size:16px;font-weight:bold;text-align:center;\r\n  vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 400px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Id_Client<\/span><\/th>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Name<\/span><br>        <\/th>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">First Name<\/span><br>        <\/th>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Age<\/span><br>        <\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-lyi1\">1<\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Martin<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Germaine<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">32<\/span><br>        <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">2<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Culprit<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Thomas<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">22<\/span><br>        <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">3<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Albanez<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Francis<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">40<\/span><br>        <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">4<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">De Jonqui\u00e8re<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Martine<\/span><br>        <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">33<\/span><br>        <\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-61617fd elementor-widget elementor-widget-text-editor\" data-id=\"61617fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>CLIENTS is the &#8220;relative&#8221; table. If customer n\u00b04, Martine de Jonqui\u00e8re, were to divorce and resume her maiden name (Heras) tomorrow, we would simply modify this information in the &#8220;relative&#8221; table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-004f15d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"004f15d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Understanding foreign keys<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48d1845 elementor-widget elementor-widget-heading\" data-id=\"48d1845\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Table COMMANDES<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-415a4c1 elementor-widget elementor-widget-html\" data-id=\"415a4c1\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-97aw{font-family:\"Trebuchet MS\", Helvetica, sans-serif !important;font-size:16px;text-align:center;vertical-align:top}\r\n.tg .tg-lyi1{font-family:\"Trebuchet MS\", Helvetica, sans-serif !important;font-size:16px;font-weight:bold;text-align:center;\r\n  vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 375px\">\r\n<colgroup>\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 100px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Id_Commande<\/span><br>     <\/th>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Date_Commande<\/span><br>      <\/th>\r\n    <th class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">Id_Client<\/span><br>       <\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">1<\/span><br>       <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">11\/04\/2023<\/span><br>      <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">4<\/span><br>       <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">2<\/span><br>       <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">10\/05\/2023<\/span><br>      <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">3<\/span><br>       <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">3<\/span><br>       <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">12\/05\/2023<\/span><br>      <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">4<\/span><br>       <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">4<\/span><br>       <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">26\/05\/2023<\/span><br>      <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">4<\/span><br>       <\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-lyi1\"><span style=\"font-style:normal;text-decoration:none;color:#000;background-color:transparent\">5<\/span><br>       <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">16\/06\/2023<\/span><br>      <\/td>\r\n    <td class=\"tg-97aw\"><span style=\"font-weight:400;font-style:normal;text-decoration:none;color:#000;background-color:transparent\">1<\/span><br>       <\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b837076 elementor-widget elementor-widget-text-editor\" data-id=\"b837076\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In this example, we find the &#8220;Customer_ID&#8221; column in the ORDERS table (which is the &#8220;daughter&#8221; table). It points to the &#8220;Id_Client&#8221; column in the CLIENTS table. In this way, we would know by means of a join that Martine de Jonqui\u00e8res placed three orders: once in April and twice in June.<\/p><p>In the CUSTOMERS table, the Customer_ID column is the primary key.<\/p><p>In the ORDERS table, the Customer_ID column is the foreign key.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eeab2fa e-flex e-con-boxed e-con\" data-id=\"eeab2fa\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3c7a851 elementor-widget elementor-widget-heading\" data-id=\"3c7a851\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Advantages of foreign keys<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-29b2f88 elementor-widget elementor-widget-heading\" data-id=\"29b2f88\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Referential integrity<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d0aca7 elementor-widget elementor-widget-text-editor\" data-id=\"2d0aca7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The main advantage of using foreign keys is referential integrity: no row in the child table will be complete and valid until a corresponding record exists in the parent table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e31505c elementor-widget elementor-widget-heading\" data-id=\"e31505c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Consistency of information<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-decf222 elementor-widget elementor-widget-text-editor\" data-id=\"decf222\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>All tables referencing the foreign key are guaranteed to produce consistent, up-to-date data. As a reminder, if Martine de Jonqui\u00e8res changes her name, this change will be visible in all tables referencing her identifier.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b0607d2 e-flex e-con-boxed e-con\" data-id=\"b0607d2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-38c547c elementor-widget elementor-widget-heading\" data-id=\"38c547c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Disadvantages of foreign keys<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-39f5de1 elementor-widget elementor-widget-heading\" data-id=\"39f5de1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Reduced processing speed<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f58e33e elementor-widget elementor-widget-text-editor\" data-id=\"f58e33e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Of course, the foreign key will mean longer processing times. Each time you insert a new row in a table such as ORDERS, you&#8217;ll need to check whether the corresponding customer identifier exists in the CUSTOMERS table.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-202073d elementor-widget elementor-widget-heading\" data-id=\"202073d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Complexity<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-016bcda elementor-widget elementor-widget-text-editor\" data-id=\"016bcda\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Referring to customer_id n\u00b04 may appear more complex than simply indicating the name Martine de Jonqui\u00e8res. And so, a priori, reading a database such as the ORDERS database will not be very explicit at first.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-fc5bc25 e-flex e-con-boxed e-con\" data-id=\"fc5bc25\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-754b3a3 elementor-widget elementor-widget-heading\" data-id=\"754b3a3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Recommended use<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-40f528c elementor-widget elementor-widget-text-editor\" data-id=\"40f528c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Despite the disadvantages of using foreign keys, the use of foreign keys is highly recommended for anyone responsible for designing SQL database management systems. In the long term, it&#8217;s a win-win situation. To put it simply, it&#8217;s important to use foreign keys whenever you&#8217;re dealing with a type of data that is likely to evolve over time. The examples given here clearly illustrate what can be gained. And so, it&#8217;s crucial to define foreign keys right from the design stage of an SQL database.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL DELETE: How do I use this query?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\" target=\"_blank\" rel=\"noopener\">SQL DELETE: How do I use this query?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9260514 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9260514\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to manage SQL databases<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-893bb19 e-flex e-con-boxed e-con\" data-id=\"893bb19\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b907070 elementor-widget elementor-widget-html\" data-id=\"b907070\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What use is a foreign key?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Let's imagine you're managing a table called Articles, in which there's a column called Category. For each item, this category must be filled in individually. For example, we could have the category \"Metal product\". However, overnight, legislation changes and this category now becomes \"Metal-based product\".\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Consistency of information\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"All tables referencing the foreign key are guaranteed to produce consistent, up-to-date data. For the record, if Martine de Jonqui\u00e8res changes her name, this change will be visible from all tables referencing her identifier.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"Reduced processing speed\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Of course, the foreign key will imply a longer computer processing time. Every time we insert a new row in a table such as ORDERS, we'll need to check whether the corresponding customer identifier exists in the CUSTOMERS table.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re designing an SQL database management system, it&#8217;s in your interest to know and implement the foreign key system. In the long term, it&#8217;s a win-win situation. A foreign key is a column (or several columns) in a database that is linked to the primary key column of another table. The primary key in [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":179578,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Unlocking the Power of SQL Foreign Keys: Definition and Applications<\/title>\n<meta name=\"description\" content=\"Discover what SQL foreign keys are and how they enhance database integrity and relationships, enabling efficient data management and ensuring referential integrity in relational database systems.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unlocking the Power of SQL Foreign Keys: Definition and Applications\" \/>\n<meta property=\"og:description\" content=\"If you&#039;re designing an SQL database management system, it&#039;s in your interest to know and implement the foreign key system. In the long term, it&#039;s a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-13T19:31:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-23T12:58:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/05\/sql-key.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"422\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Unlocking the Power of SQL Foreign Keys: Definition and Applications\",\"datePublished\":\"2024-05-13T19:31:51+00:00\",\"dateModified\":\"2024-02-23T12:58:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\"},\"wordCount\":795,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\",\"url\":\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\",\"name\":\"Unlocking the Power of SQL Foreign Keys: Definition and Applications\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-05-13T19:31:51+00:00\",\"dateModified\":\"2024-02-23T12:58:52+00:00\",\"description\":\"Discover what SQL foreign keys are and how they enhance database integrity and relationships, enabling efficient data management and ensuring referential integrity in relational database systems.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Unlocking the Power of SQL Foreign Keys: Definition and Applications","description":"Discover what SQL foreign keys are and how they enhance database integrity and relationships, enabling efficient data management and ensuring referential integrity in relational database systems.","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:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications","og_locale":"en_GB","og_type":"article","og_title":"Unlocking the Power of SQL Foreign Keys: Definition and Applications","og_description":"If you're designing an SQL database management system, it's in your interest to know and implement the foreign key system. In the long term, it's a","og_url":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-05-13T19:31:51+00:00","article_modified_time":"2024-02-23T12:58:52+00:00","og_image":[{"width":768,"height":422,"url":"https:\/\/datascientest.com\/en\/files\/2024\/05\/sql-key.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Unlocking the Power of SQL Foreign Keys: Definition and Applications","datePublished":"2024-05-13T19:31:51+00:00","dateModified":"2024-02-23T12:58:52+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications"},"wordCount":795,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications","url":"https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications","name":"Unlocking the Power of SQL Foreign Keys: Definition and Applications","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-05-13T19:31:51+00:00","dateModified":"2024-02-23T12:58:52+00:00","description":"Discover what SQL foreign keys are and how they enhance database integrity and relationships, enabling efficient data management and ensuring referential integrity in relational database systems.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/unlocking-the-power-of-sql-foreign-keys-definition-and-applications"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179576"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=179576"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/179576\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/179578"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=179576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=179576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=179576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}