{"id":9,"date":"2024-09-17T06:35:01","date_gmt":"2024-09-17T06:35:01","guid":{"rendered":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/?page_id=9"},"modified":"2024-10-14T06:45:41","modified_gmt":"2024-10-14T06:45:41","slug":"tabeli-normaliseerimine","status":"publish","type":"page","link":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/","title":{"rendered":"Tabeli normaliseerimine"},"content":{"rendered":"\n<p><em>Normaliseerimine<\/em> &#8211; andmebaasi andmete korrastamine.<\/p>\n\n\n\n<p><strong>-Otsime taelites- <\/strong><br>&#8211;KORDUSED <br>&#8211;VASTUOLUD<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"356\" height=\"169\" src=\"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png\" alt=\"\" class=\"wp-image-53\" srcset=\"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png 356w, https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg-300x142.png 300w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/figure>\n\n\n\n<p><strong>1 NormaalKuju (1NF)<\/strong><\/p>\n\n\n\n<p>Tabeli atribuudid on unikaalse nimega.<br>Igas veerus on aimult \u00fche t\u00fc\u00fcbi andmed.<br>Igal tabelil on Primaarv\u00f5ti.<br>Igas lahtris on ainult \u00fchte v\u00e4\u00e4rtust, see t\u00e4hendab kui \u00f5pilasel on kaks mobiilinumbrit, siis ei tohi neid sisestada \u00fche lahtrisse.<\/p>\n\n\n\n<p><strong>2 NormaalKuju (2NF)<\/strong><\/p>\n\n\n\n<p>T\u00e4idetud 1NF<br><br>Luuakse eraldi tabeleid mis on seotud primaarv\u00f5tmega (V\u00d5\u00d5TV\u00d5TI, V\u00e4line V\u00d5TI)<\/p>\n\n\n\n<p><strong>3 NormaalKuju (3NF)<\/strong><\/p>\n\n\n\n<p>T\u00e4idetud 1NF , 2NF <br><br>on vaja kustutada need veerud, mis ei ole otse seotud ptimaarv\u00f5tmega.<br>N\u00e4iteks, kui tabelis opilane on veerg kwskmine_hinne, siis keskmin:hinne ei ole seotud, primaarv\u00f5tmega.<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/support.microsoft.com\/et-ee\/topic\/andmete-normaliseerimine-tabelianal%C3%BCsaatori-abil-8edbb763-5bab-4fbc-b62d-c17b1a40bbe2\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Normaliseerimine &#8211; andmebaasi andmete korrastamine. -Otsime taelites- &#8211;KORDUSED &#8211;VASTUOLUD 1 NormaalKuju (1NF) Tabeli atribuudid on unikaalse nimega.Igas veerus on aimult \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 mobiilinumbrit, siis ei tohi neid sisestada \u00fche lahtrisse. 2 NormaalKuju (2NF) T\u00e4idetud 1NF Luuakse eraldi tabeleid mis on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"plugin_block_meta":"","ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"class_list":["post-9","page","type-page","status-publish","hentry","entry","owp-thumbs-layout-horizontal","owp-btn-normal","owp-tabs-layout-horizontal","has-no-thumbnails","has-product-nav"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud<\/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:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud\" \/>\n<meta property=\"og:description\" content=\"Normaliseerimine &#8211; andmebaasi andmete korrastamine. -Otsime taelites- &#8211;KORDUSED &#8211;VASTUOLUD 1 NormaalKuju (1NF) Tabeli atribuudid on unikaalse nimega.Igas veerus on aimult \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 mobiilinumbrit, siis ei tohi neid sisestada \u00fche lahtrisse. 2 NormaalKuju (2NF) T\u00e4idetud 1NF Luuakse eraldi tabeleid mis on [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:site_name\" content=\"Aleksandra Semjonova &otilde;pimapp | portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-14T06:45:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png\" \/>\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 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\",\"url\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\",\"name\":\"Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/1_5bgudC0Dj232aKM97N3zGg.png\",\"datePublished\":\"2024-09-17T06:35:01+00:00\",\"dateModified\":\"2024-10-14T06:45:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/1_5bgudC0Dj232aKM97N3zGg.png\",\"contentUrl\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/1_5bgudC0Dj232aKM97N3zGg.png\",\"width\":356,\"height\":169},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/tabeli-normaliseerimine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabeli normaliseerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/#website\",\"url\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/\",\"name\":\"Aleksandra Semjonova &otilde;pimapp | portfoolio\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksandrasemjonova23.thkit.ee\\\/WP\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud","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:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/","og_locale":"en_US","og_type":"article","og_title":"Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud","og_description":"Normaliseerimine &#8211; andmebaasi andmete korrastamine. -Otsime taelites- &#8211;KORDUSED &#8211;VASTUOLUD 1 NormaalKuju (1NF) Tabeli atribuudid on unikaalse nimega.Igas veerus on aimult \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 mobiilinumbrit, siis ei tohi neid sisestada \u00fche lahtrisse. 2 NormaalKuju (2NF) T\u00e4idetud 1NF Luuakse eraldi tabeleid mis on [&hellip;]","og_url":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/","og_site_name":"Aleksandra Semjonova &otilde;pimapp | portfoolio","article_modified_time":"2024-10-14T06:45:41+00:00","og_image":[{"url":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/","url":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/","name":"Tabeli normaliseerimine - Aleksandra Semjonova &otilde;pimapp | portfoolio NormaalKuju Normaliseerimine T\u00e4idetud","isPartOf":{"@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/#primaryimage"},"image":{"@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/#primaryimage"},"thumbnailUrl":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png","datePublished":"2024-09-17T06:35:01+00:00","dateModified":"2024-10-14T06:45:41+00:00","breadcrumb":{"@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/#primaryimage","url":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png","contentUrl":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-content\/uploads\/2024\/10\/1_5bgudC0Dj232aKM97N3zGg.png","width":356,"height":169},{"@type":"BreadcrumbList","@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/tabeli-normaliseerimine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/"},{"@type":"ListItem","position":2,"name":"Tabeli normaliseerimine"}]},{"@type":"WebSite","@id":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/#website","url":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/","name":"Aleksandra Semjonova &otilde;pimapp | portfoolio","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"}]}},"_links":{"self":[{"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":11,"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":54,"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/9\/revisions\/54"}],"wp:attachment":[{"href":"https:\/\/aleksandrasemjonova23.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}