Warning: foreach() argument must be of type array|object, false given in /data01/virt140703/domeenid/www.mareklukk24.thkit.ee/htdocs/wp/wp-content/plugins/real3d-flipbook-lite/includes/Real3DFlipbook.php on line 1635
{"id":656,"date":"2025-05-02T08:14:34","date_gmt":"2025-05-02T06:14:34","guid":{"rendered":"https:\/\/rocketleaugedaddy.wordpress.com\/?page_id=656"},"modified":"2025-05-02T08:14:34","modified_gmt":"2025-05-02T06:14:34","slug":"tabeli-normaliseerimine","status":"publish","type":"page","link":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/","title":{"rendered":"Tabeli normaliseerimine"},"content":{"rendered":"\n

<\/p>\n\n\n\n

Normaliseerimine -andmebaasi andmete korrastamine<\/p>\n\n\n\n

Otsime tabelites-
—KORDUSED(\u041f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)
—VASTUOLUD(\u041f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f)<\/p>\n\n\n\n

1 NormaalKuju(1NF)<\/strong><\/p>\n\n\n\n

Tabeli atribuudid on unikalse 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 \u00f5pilased on kaks mobiilinumbrit, siis ei tohi neid sisestada \u00fche lahtrisse — on vaja luua eraldi tabeli.<\/p>\n\n\n\n

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

T\u00e4idetud 1NF
Luuakse eraldi tabeleid mis on seotud primaarv\u00f5tmega(V\u00d5\u00d5RV\u00d5TI,V\u00e4line V\u00d5TI)<\/p>\n\n\n\n

3 NormaalKiju(3NF)<\/p>\n\n\n\n

T\u00e4idetud 1NF, 2NF
On vaja kustutada need veerud,mis ei ole otse seotud primaarv\u00f5tmega
N\u00e4iteks, kui tabelis opilane on veerg keskmine_hinne, siis keskmine_hinne ei ole seotud primaarv\u00f5tmega<\/p>\n","protected":false},"excerpt":{"rendered":"

Normaliseerimine -andmebaasi andmete korrastamine Otsime tabelites-—KORDUSED(\u041f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)—VASTUOLUD(\u041f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f) 1 NormaalKuju(1NF) Tabeli atribuudid on unikalse nimegaIgas veerus on ainult \u00fche t\u00fc\u00fcbi andmedIgal tabelil on Primaarv\u00f5tiIgas […]<\/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-656","page","type-page","status-publish","hentry"],"yoast_head":"\nTabeli normaliseerimine - Marek Lukk portfolio | rus<\/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:\/\/mareklukk24.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=\"Tabeli normaliseerimine - Marek Lukk portfolio | rus\" \/>\n<meta property=\"og:description\" content=\"Normaliseerimine -andmebaasi andmete korrastamine Otsime tabelites-—KORDUSED(\u041f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)—VASTUOLUD(\u041f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f) 1 NormaalKuju(1NF) Tabeli atribuudid on unikalse nimegaIgas veerus on ainult \u00fche t\u00fc\u00fcbi andmedIgal tabelil on Primaarv\u00f5tiIgas […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/\" \/>\n<meta property=\"og:site_name\" content=\"Marek Lukk portfolio | rus\" \/>\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:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/tabeli-normaliseerimine\\\/\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/tabeli-normaliseerimine\\\/\",\"name\":\"Tabeli normaliseerimine - Marek Lukk portfolio | rus\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/#website\"},\"datePublished\":\"2025-05-02T06:14:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/tabeli-normaliseerimine\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/tabeli-normaliseerimine\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/tabeli-normaliseerimine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabeli normaliseerimine\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/#website\",\"url\":\"https:\\\/\\\/mareklukk24.thkit.ee\\\/wp\\\/ru\\\/\",\"name\":\"Marek Lukk portfolio | rus\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mareklukk24.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":"Tabeli normaliseerimine - Marek Lukk portfolio | rus","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:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/","og_locale":"ru_RU","og_type":"article","og_title":"Tabeli normaliseerimine - Marek Lukk portfolio | rus","og_description":"Normaliseerimine -andmebaasi andmete korrastamine Otsime tabelites-—KORDUSED(\u041f\u043e\u0432\u0442\u043e\u0440\u0435\u043d\u0438\u044f)—VASTUOLUD(\u041f\u0440\u043e\u0442\u0438\u0432\u043e\u0440\u0435\u0447\u0438\u044f) 1 NormaalKuju(1NF) Tabeli atribuudid on unikalse nimegaIgas veerus on ainult \u00fche t\u00fc\u00fcbi andmedIgal tabelil on Primaarv\u00f5tiIgas […]","og_url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/","og_site_name":"Marek Lukk portfolio | rus","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:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/","url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/","name":"Tabeli normaliseerimine - Marek Lukk portfolio | rus","isPartOf":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/#website"},"datePublished":"2025-05-02T06:14:34+00:00","breadcrumb":{"@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/tabeli-normaliseerimine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/"},{"@type":"ListItem","position":2,"name":"Tabeli normaliseerimine"}]},{"@type":"WebSite","@id":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/#website","url":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/","name":"Marek Lukk portfolio | rus","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mareklukk24.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:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/656","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/comments?post=656"}],"version-history":[{"count":0,"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/656\/revisions"}],"wp:attachment":[{"href":"https:\/\/mareklukk24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=656"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}