{"version":"1.0","provider_name":"Nikita Orlenko \/ portfoolio \/ RU","provider_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru","author_name":"Nikita Orlenko","author_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/author\/nikita-orlenko\/","title":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"k8utAPlkAO\"><a href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/\">\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/embed\/#?secret=k8utAPlkAO\" width=\"600\" height=\"338\" title=\"\u00ab\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b\u00bb &#8212; Nikita Orlenko \/ portfoolio \/ RU\" data-secret=\"k8utAPlkAO\" 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:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Normaliseerimine &#8212; andmebaasi andmete korrastamine Otsime tabelites: &#8212;Kordused(\u043f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f) &#8212;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 t\u00fc\u00fcbi andmed Igal tabelil on Primaarv\u00f5ti Igas lahtris on ainult \u00fchte v\u00e4\u00e4rtust, see t\u00e4hendab kui \u00f5pilasel on kaks mobiilnumbrit, siis ei tohi neid sisestada \u00fche lahtrisse &#8212; on vaja luua eraldi tabeli 2.NormaalKuju(2NF) T\u00e4idatut 1NF [&hellip;]"}