{"id":311,"date":"2025-05-02T09:13:39","date_gmt":"2025-05-02T06:13:39","guid":{"rendered":"https:\/\/romanzaitsevtarpv.wordpress.com\/?page_id=311"},"modified":"2025-05-02T09:13:39","modified_gmt":"2025-05-02T06:13:39","slug":"andmebaasi-proekteerimine","status":"publish","type":"page","link":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/","title":{"rendered":"Andmebaasi Proekteerimine"},"content":{"rendered":"\n<p>Tabeli normaliseerimine<br>Normaliseerimine &#8211; andmebaasi andmete korrastamine.<br>entaarid<br>Otsime tabelites &#8211;<br>KORDUSED (\u043f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)<br>&#8211; VASTUOLUD (\u043f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f)<br><\/p>\n\n\n\n<p><strong><em>1 NormaalKuju (1NF)<\/em><\/strong><\/p>\n\n\n\n<p><br>Tabeli atribuudid on unikaalse nimega.<br>Igas veerus on ainult \u00fche tu\u00fcbi andmed.<br>Igal tabelil on Primaav\u00f5ti.<br>Igas lahtris on ainult \u00fchte v\u00e4\u00e4rtust, see t\u00e4hendab kui \u00f5pilasel on kaks mobiilinumbrit,<br>siis ei tohi neid sisestada \u00fche lahtrisse &#8211; on vaja luua eraldi tabeli.<\/p>\n\n\n\n<p><strong><em>2 NormaalKuju (2NF)<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>T\u00e4idetud 1NF<\/li>\n\n\n\n<li>Luuakse eraldi tabeleid mis on seotud primaarv\u00f6tmega (V\u00d6\u00d5RVTI, V\u00e4line V\u00d5TI)<br><\/li>\n<\/ul>\n\n\n\n<p><strong><em>3 NormaalKuju (3NF)<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>T\u00e4idetud 1NF, 2NF<\/li>\n\n\n\n<li>on vaja kustutada need veerud, mis ei ole otse seotud primaarvtmega.<\/li>\n\n\n\n<li>N\u00e4iteks, kui tabelis opilane on veerg keskmine _hinne, siis keskmine_hinne ei ole seotud primaarv\u00f5tmega<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-311","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>Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG<\/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:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG\" \/>\n<meta property=\"og:description\" content=\"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;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/\" \/>\n<meta property=\"og:site_name\" content=\"Roman Zaitsev Portfoolio | ENG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/andmebaasi-proekteerimine\\\/\",\"url\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/andmebaasi-proekteerimine\\\/\",\"name\":\"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"datePublished\":\"2025-05-02T06:13:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/andmebaasi-proekteerimine\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/andmebaasi-proekteerimine\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/andmebaasi-proekteerimine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Andmebaasi Proekteerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Roman Zaitsev Portfoolio | ENG\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/romanzaitsev24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG","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:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/","og_locale":"en_GB","og_type":"article","og_title":"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG","og_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;]","og_url":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/","og_site_name":"Roman Zaitsev Portfoolio | ENG","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/","url":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/","name":"Andmebaasi Proekteerimine - Roman Zaitsev Portfoolio | ENG","isPartOf":{"@id":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/#website"},"datePublished":"2025-05-02T06:13:39+00:00","breadcrumb":{"@id":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/andmebaasi-proekteerimine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Andmebaasi Proekteerimine"}]},{"@type":"WebSite","@id":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/","name":"Roman Zaitsev Portfoolio | ENG","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/311","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=311"}],"version-history":[{"count":0,"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/311\/revisions"}],"wp:attachment":[{"href":"https:\/\/romanzaitsev24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}