{"version":"1.0","provider_name":"Roman Zaitsev Portfoolio | EST","provider_url":"https:\/\/romanzaitsev24.thkit.ee\/wp","author_name":"admin","author_url":"https:\/\/romanzaitsev24.thkit.ee\/wp\/blog\/author\/admin\/","title":"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | EST","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"LO81vg0CCu\"><a href=\"https:\/\/romanzaitsev24.thkit.ee\/wp\/andmebaasi-proekteerimine\/\">Andmebaasi Proekteerimine<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/romanzaitsev24.thkit.ee\/wp\/andmebaasi-proekteerimine\/embed\/#?secret=LO81vg0CCu\" width=\"600\" height=\"338\" title=\"&#8220;Andmebaasi Proekteerimine&#8221; &#8212; Roman Zaitsev Portfoolio | EST\" data-secret=\"LO81vg0CCu\" 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\/\/# sourceURL=https:\/\/romanzaitsev24.thkit.ee\/wp\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Tabeli normaliseerimineNormaliseerimine &#8211; andmebaasi andmete korrastamine.entaaridOtsime tabelites &#8211;KORDUSED (\u043f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)&#8211; VASTUOLUD (\u043f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f) 1 NormaalKuju (1NF) Tabeli atribuudid on unikaalse nimega.Igas veerus on ainult \u00fche tu\u00fcbi andmed.Igal tabelil on Primaav\u00f5ti.Igas lahtris on ainult \u00fchte v\u00e4\u00e4rtust, see t\u00e4hendab kui \u00f5pilasel on kaks mobiilinumbrit,siis ei tohi neid sisestada \u00fche lahtrisse &#8211; on vaja luua eraldi tabeli. 2 NormaalKuju (2NF) [&hellip;]"}