{"id":628,"date":"2025-05-02T09:15:49","date_gmt":"2025-05-02T06:15:49","guid":{"rendered":"https:\/\/nikiforovnikitaportfolio.wordpress.com\/?page_id=628"},"modified":"2025-10-30T12:34:45","modified_gmt":"2025-10-30T10:34:45","slug":"tabeli-normaliseerimine","status":"publish","type":"page","link":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628","title":{"rendered":"Tabeli normaliseerimine"},"content":{"rendered":"\n

Normaliseerimine – andmebaasi andmed korrutamine<\/p>\n\n\n\n

Otsime tabelites :
– KORDUSED
– VASTUOLUD<\/p>\n\n\n\n

    \n
  1. NormaalKuju (1NF)<\/li>\n<\/ol>\n\n\n\n
      \n
    1. Tabeli atribuudid on unikaalse nimiga<\/li>\n\n\n\n
    2. Igas veerus on ainult \u00fche t\u00fc\u00fcbi andmed<\/li>\n\n\n\n
    3. Igal tabelil on Primaarv\u00f5ti<\/li>\n\n\n\n
    4. Igas lahtris on ainult \u00fchte v\u00e4\u00e4rtustu t\u00e4hendab kui \u00f5pilasel on kaks mobilinumbrit, sis ei tohi neld sisestada \u00fchelahtrisse – on vaja luua erildi tabeli<\/li>\n<\/ol>\n\n\n\n

      2. NormaalKuju(2NF)<\/p>\n\n\n\n

      T\u00e4idetud 1NF
      Luuakse eraldi tabelid mis on seotud primaav\u00f5tmega(V\u00d5\u00d5V\u00d5TI, Valine V\u00d5TI)<\/p>\n\n\n\n

      3. NormaalKuju(3NF)<\/p>\n\n\n\n

      -T\u00e4idetud 1NF, 2NF
      -On vaja justutad need veeerud , mis ei ole otse seotud primaarv\u00f5tmega
      -Na\u00e4iteks, kui tabelis \u00f5pilane on veerg keskmine_hinne, siis keskmine_hinne ei ole seotud primaav\u00f5tmega<\/p>\n\n\n\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      Normaliseerimine – andmebaasi andmed korrutamine Otsime tabelites :– KORDUSED– VASTUOLUD 2. NormaalKuju(2NF) T\u00e4idetud 1NFLuuakse eraldi tabelid mis on seotud primaav\u00f5tmega(V\u00d5\u00d5V\u00d5TI, Valine V\u00d5TI) 3. NormaalKuju(3NF) -T\u00e4idetud 1NF, 2NF-On vaja justutad need veeerud , mis ei ole otse seotud primaarv\u00f5tmega-Na\u00e4iteks, kui tabelis \u00f5pilane on veerg keskmine_hinne, siis keskmine_hinne ei ole seotud primaav\u00f5tmega<\/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-628","page","type-page","status-publish","hentry"],"yoast_head":"\nTabeli normaliseerimine - Nikita Nikiforov Portfolio<\/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:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabeli normaliseerimine - Nikita Nikiforov Portfolio\" \/>\n<meta property=\"og:description\" content=\"Normaliseerimine – andmebaasi andmed korrutamine Otsime tabelites :– KORDUSED– VASTUOLUD 2. NormaalKuju(2NF) T\u00e4idetud 1NFLuuakse eraldi tabelid mis on seotud primaav\u00f5tmega(V\u00d5\u00d5V\u00d5TI, Valine V\u00d5TI) 3. NormaalKuju(3NF) -T\u00e4idetud 1NF, 2NF-On vaja justutad need veeerud , mis ei ole otse seotud primaarv\u00f5tmega-Na\u00e4iteks, kui tabelis \u00f5pilane on veerg keskmine_hinne, siis keskmine_hinne ei ole seotud primaav\u00f5tmega\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Nikiforov Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-30T10:34:45+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:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=628\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=628\",\"name\":\"Tabeli normaliseerimine - Nikita Nikiforov Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\"},\"datePublished\":\"2025-05-02T06:15:49+00:00\",\"dateModified\":\"2025-10-30T10:34:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=628#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=628\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?page_id=628#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabeli normaliseerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"name\":\"Nikita Nikiforov Portfolio\",\"description\":\"Noorem Tarkvarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Nikita Nikiforov Portfolio\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png\",\"width\":150,\"height\":137,\"caption\":\"Nikita Nikiforov Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitanikiforov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tabeli normaliseerimine - Nikita Nikiforov Portfolio","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:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628","og_locale":"et_EE","og_type":"article","og_title":"Tabeli normaliseerimine - Nikita Nikiforov Portfolio","og_description":"Normaliseerimine – andmebaasi andmed korrutamine Otsime tabelites :– KORDUSED– VASTUOLUD 2. NormaalKuju(2NF) T\u00e4idetud 1NFLuuakse eraldi tabelid mis on seotud primaav\u00f5tmega(V\u00d5\u00d5V\u00d5TI, Valine V\u00d5TI) 3. NormaalKuju(3NF) -T\u00e4idetud 1NF, 2NF-On vaja justutad need veeerud , mis ei ole otse seotud primaarv\u00f5tmega-Na\u00e4iteks, kui tabelis \u00f5pilane on veerg keskmine_hinne, siis keskmine_hinne ei ole seotud primaav\u00f5tmega","og_url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628","og_site_name":"Nikita Nikiforov Portfolio","article_modified_time":"2025-10-30T10:34:45+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628","name":"Tabeli normaliseerimine - Nikita Nikiforov Portfolio","isPartOf":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website"},"datePublished":"2025-05-02T06:15:49+00:00","dateModified":"2025-10-30T10:34:45+00:00","breadcrumb":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?page_id=628#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Tabeli normaliseerimine"}]},{"@type":"WebSite","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#website","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","name":"Nikita Nikiforov Portfolio","description":"Noorem Tarkvarendaja","publisher":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":"Organization","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#organization","name":"Nikita Nikiforov Portfolio","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","contentUrl":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/0ce66b2c514f64099fc903d1deea8e5c-150x137-removebg-preview.png","width":150,"height":137,"caption":"Nikita Nikiforov Portfolio"},"image":{"@id":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/628","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=628"}],"version-history":[{"count":1,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/628\/revisions"}],"predecessor-version":[{"id":1129,"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=\/wp\/v2\/pages\/628\/revisions\/1129"}],"wp:attachment":[{"href":"https:\/\/nikitanikiforov24.thkit.ee\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=628"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}