{"id":563,"date":"2025-05-02T09:09:37","date_gmt":"2025-05-02T06:09:37","guid":{"rendered":"https:\/\/nikitaorlenko.wordpress.com\/?page_id=563"},"modified":"2025-10-21T06:41:31","modified_gmt":"2025-10-21T06:41:31","slug":"tabeli-normaliseerimine","status":"publish","type":"page","link":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/","title":{"rendered":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b"},"content":{"rendered":"\n<p>Normaliseerimine &#8212; andmebaasi andmete korrastamine<\/p>\n\n\n\n<p>Otsime tabelites:<\/p>\n\n\n\n<p>&#8212;Kordused(\u043f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)<\/p>\n\n\n\n<p>&#8212;Vastuolud(\u043f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f)<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/#1NormaalKuju1NF\" >1.NormaalKuju(1NF)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/#2NormaalKuju2NF\" >2.NormaalKuju(2NF)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/#3_NormaalKuju3NF\" >3. NormaalKuju(3NF)<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1NormaalKuju1NF\"><\/span>1.NormaalKuju(1NF)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tabeli atribuudid on unikaalse nimega<\/p>\n\n\n\n<p>Igas veerus on ainult \u00fche t\u00fc\u00fcbi andmed<\/p>\n\n\n\n<p>Igal tabelil on Primaarv\u00f5ti<\/p>\n\n\n\n<p>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<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2NormaalKuju2NF\"><\/span>2.NormaalKuju(2NF)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p> <\/p>\n\n\n\n<p>T\u00e4idatut 1NF<\/p>\n\n\n\n<p>Luuakse eraldi tabeleid mis on seotud primaarv\u00f5tmega (V\u00d5\u00d5RV\u00d5TI, V\u00e4line V\u00d5TI)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_NormaalKuju3NF\"><\/span>3. NormaalKuju(3NF)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u00e4idetud 1NF, 2NF<\/p>\n\n\n\n<p>On vaja kustutada need veerud, mis ei ole otse seotud primaarv\u00f5tmega<\/p>\n\n\n\n<p>N\u00e4iteks, kui tabelis opilane on veerg <strong>keskmine_hinne<\/strong>, siis <strong>keskmine_hinne<\/strong> ei ole seotud primaarv\u00f5tmega<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-563","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU\" \/>\n<meta property=\"og:description\" content=\"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;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Orlenko \/ portfoolio \/ RU\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-21T06:41:31+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 \u043c\u0438\u043d\u0443\u0442\u0430\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/tabeli-normaliseerimine\\\/\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/tabeli-normaliseerimine\\\/\",\"name\":\"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \\\/ portfoolio \\\/ RU\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/#website\"},\"datePublished\":\"2025-05-02T06:09:37+00:00\",\"dateModified\":\"2025-10-21T06:41:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/tabeli-normaliseerimine\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/tabeli-normaliseerimine\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/tabeli-normaliseerimine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/#website\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/\",\"name\":\"Nikita Orlenko \\\/ portfoolio \\\/ RU\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/ru\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU","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:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/","og_locale":"ru_RU","og_type":"article","og_title":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU","og_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;]","og_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/","og_site_name":"Nikita Orlenko \/ portfoolio \/ RU","article_modified_time":"2025-10-21T06:41:31+00:00","twitter_card":"summary_large_image","twitter_misc":{"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"1 \u043c\u0438\u043d\u0443\u0442\u0430"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/","name":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b - Nikita Orlenko \/ portfoolio \/ RU","isPartOf":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/#website"},"datePublished":"2025-05-02T06:09:37+00:00","dateModified":"2025-10-21T06:41:31+00:00","breadcrumb":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/tabeli-normaliseerimine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/"},{"@type":"ListItem","position":2,"name":"\u041d\u043e\u0440\u043c\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044b"}]},{"@type":"WebSite","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/#website","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/","name":"Nikita Orlenko \/ portfoolio \/ RU","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"}]}},"_links":{"self":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/pages\/563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/comments?post=563"}],"version-history":[{"count":2,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/pages\/563\/revisions"}],"predecessor-version":[{"id":862,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/pages\/563\/revisions\/862"}],"wp:attachment":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/ru\/wp-json\/wp\/v2\/media?parent=563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}