{"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-11-13T12:48:02","modified_gmt":"2025-11-13T12:48:02","slug":"tabeli-normaliseerimine","status":"publish","type":"page","link":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/","title":{"rendered":"Tabeli normaliseerimine"},"content":{"rendered":"\n<p>Normaliseerimine &#8211; andmebaasi andmete korrastamine<\/p>\n\n\n\n<p>Otsime tabelites:<\/p>\n\n\n\n<p>&#8211;Kordused(\u043f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)<\/p>\n\n\n\n<p>&#8211;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\/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\/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\/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  &#8211; 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 &#8211; andmebaasi andmete korrastamine Otsime 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 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 &#8211; on vaja luua eraldi tabeli 2.NormaalKuju(2NF) T\u00e4idatut 1NF [&hellip;]<\/p>\n","protected":false},"author":2,"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>Tabeli normaliseerimine - Nikita Orlenko \/ Portfoolio<\/title>\n<meta name=\"description\" content=\"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist\" \/>\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\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabeli normaliseerimine - Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"og:description\" content=\"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Orlenko \/ Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T12:48:02+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\",\"name\":\"Tabeli normaliseerimine - Nikita Orlenko \\\/ Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/#website\"},\"datePublished\":\"2025-05-02T06:09:37+00:00\",\"dateModified\":\"2025-11-13T12:48:02+00:00\",\"description\":\"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabeli normaliseerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/#website\",\"url\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/\",\"name\":\"Nikita Orlenko \\\/ Portfoolio\",\"description\":\"Saate kontakt minuga\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitaorlenko24.thkit.ee\\\/WP\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tabeli normaliseerimine - Nikita Orlenko \/ Portfoolio","description":"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist","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\/tabeli-normaliseerimine\/","og_locale":"et_EE","og_type":"article","og_title":"Tabeli normaliseerimine - Nikita Orlenko \/ Portfoolio","og_description":"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist","og_url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/","og_site_name":"Nikita Orlenko \/ Portfoolio","article_modified_time":"2025-11-13T12:48:02+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/","name":"Tabeli normaliseerimine - Nikita Orlenko \/ Portfoolio","isPartOf":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/#website"},"datePublished":"2025-05-02T06:09:37+00:00","dateModified":"2025-11-13T12:48:02+00:00","description":"\u00d5pi tundma AB p\u00f5hikasutajaid (, programmeerija, projekteerija), nende rolle, \u00f5iguste haldust, SQL p\u00f5hifunktsioone ja andmete normaliseerimist","breadcrumb":{"@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/tabeli-normaliseerimine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/"},{"@type":"ListItem","position":2,"name":"Tabeli normaliseerimine"}]},{"@type":"WebSite","@id":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/#website","url":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/","name":"Nikita Orlenko \/ Portfoolio","description":"Saate kontakt minuga","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/563","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=563"}],"version-history":[{"count":1,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/563\/revisions"}],"predecessor-version":[{"id":997,"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/563\/revisions\/997"}],"wp:attachment":[{"href":"https:\/\/nikitaorlenko24.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}