{"id":185,"date":"2022-03-01T15:08:40","date_gmt":"2022-03-01T13:08:40","guid":{"rendered":"https:\/\/merkulova.thkit.ee\/ta\/?page_id=185"},"modified":"2024-02-19T10:38:20","modified_gmt":"2024-02-19T08:38:20","slug":"andmebaasi-skeem","status":"publish","type":"page","link":"https:\/\/merkulova.thkit.ee\/ta\/andmebaasi-skeem\/","title":{"rendered":"Andmebaasi skeem"},"content":{"rendered":"\n<p>\u0434\u0438\u0430\u0433\u0440\u0430\u043c\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 &#8211; \u0441\u0445\u0435\u043c\u0430 \u0434\u0430\u043d\u043d\u044b\u0445<\/p>\n\n\n\n<p>\u041c\u043e\u0434\u0435\u043b\u0438:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>&#8220;\u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438-\u0441\u0432\u044f\u0437\u0438&#8221; &#8211; OLEMID &#8211; SEOSED<\/li>\n\n\n\n<li>&#8220;\u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438-\u0430\u0442\u0440\u0438\u0431\u0443\u0442\u044b-\u0441\u0432\u044f\u0437\u0438&#8221;   &#8211; OLEMID &#8211; ATRIBUUTID &#8211; SEOSED<\/li>\n\n\n\n<li>\u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043a\u0430\u044f \u043c\u043e\u0434\u0435\u043b\u044c &#8211; hierarhiline mudel<\/li>\n\n\n\n<li>\u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0430\u044f \u043c\u043e\u0434\u0435\u043b\u044c &#8211; relatsiooniline mudel \/ andmemudel<\/li>\n<\/ul>\n\n\n\n<p><strong>MS Visio<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"252\" height=\"462\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image.png\" alt=\"\" class=\"wp-image-317\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image.png 252w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-164x300.png 164w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-82x150.png 82w\" sizes=\"auto, (max-width: 252px) 100vw, 252px\" \/><\/figure>\n\n\n\n<p>OLEMID: <\/p>\n\n\n\n<p><strong>Opilane <\/strong>&#8211; esitab \u00f5pilase andmed &#8211; eesnimi, perekonnanimi. Temaga on seotud r\u00fchm.<\/p>\n\n\n\n<p><strong>Ryhm <\/strong>&#8211; on olem, mis esitab r\u00fchma, r\u00fchm kuulub osakonda.<\/p>\n\n\n\n<p><strong>Relatsiooniline andmebaasi kuju:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"408\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1-1024x408.png\" alt=\"\" class=\"wp-image-319\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1-1024x408.png 1024w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1-300x119.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1-768x306.png 768w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1-150x60.png 150w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/03\/image-1.png 1372w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"> andmebaasi skeem<\/figcaption><\/figure>\n\n\n\n<p><strong>Skeemi realisatsioon MySQL vahendiga:<\/strong><\/p>\n\n\n\n<p>CREATE TABLE &#8230;.<\/p>\n\n\n\n<p><strong>N\u00e4iteandmed<\/strong>:<\/p>\n\n\n\n<p>INSERT INTO &#8230; <\/p>\n\n\n\n<p>(1,<\/p>\n\n\n\n<p>(2,<\/p>\n\n\n\n<p>(3, <\/p>\n\n\n\n<p>Andmebaasi skeem MS SQL Server \/v\u00f5i \/ phpMyAdmin<\/p>\n\n\n\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n\n\n\n<p><strong>lucidchart.com <\/strong><br>Shapes&#8211;&gt;Entity Relationships<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8-1024x576.png\" alt=\"\" class=\"wp-image-286\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8-1024x576.png 1024w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8-300x169.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8-768x432.png 768w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8-150x84.png 150w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/11\/uml-Page-8.png 1368w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Autokooli andmebaasi skeem<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"836\" height=\"654\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/03\/image-1.png\" alt=\"\" class=\"wp-image-196\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/03\/image-1.png 836w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/03\/image-1-300x235.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/03\/image-1-768x601.png 768w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2022\/03\/image-1-150x117.png 150w\" sizes=\"auto, (max-width: 836px) 100vw, 836px\" \/><figcaption class=\"wp-element-caption\">Lucidchart.com -&gt; \u043a\u0430\u043a \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c SQL \u0434\u043b\u044f \u0431\u0430\u0437\u044b \u0434\u0430\u043d\u043d\u044b\u0445<\/figcaption><\/figure>\n\n\n\n<p><strong>ADO.net model in Visual Studio<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"570\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-5.png\" alt=\"\" class=\"wp-image-372\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-5.png 846w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-5-300x202.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-5-768x517.png 768w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-5-150x101.png 150w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/figure>\n\n\n\n<p>paremhiireklick &#8212;&gt;Generate Database from Model<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"630\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-6.png\" alt=\"\" class=\"wp-image-374\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-6.png 632w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-6-300x300.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-6-150x150.png 150w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-6-400x400.png 400w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/figure>\n\n\n\n<p>DDL  kood &#8212;&gt; Execute<\/p>\n\n\n\n<p>Kontroll in MS SQL Server Management Studio<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"915\" height=\"585\" src=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-7.png\" alt=\"\" class=\"wp-image-375\" srcset=\"https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-7.png 915w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-7-300x192.png 300w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-7-768x491.png 768w, https:\/\/merkulova.thkit.ee\/ta\/wp-content\/uploads\/2023\/11\/image-7-150x96.png 150w\" sizes=\"auto, (max-width: 915px) 100vw, 915px\" \/><\/figure>\n\n\n\n<p>palun proovi t\u00e4ita tabelid!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0434\u0438\u0430\u0433\u0440\u0430\u043c\u043c\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 &#8211; \u0441\u0445\u0435\u043c\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u041c\u043e\u0434\u0435\u043b\u0438: MS Visio OLEMID: Opilane &#8211; esitab \u00f5pilase andmed &#8211; eesnimi, perekonnanimi. Temaga on seotud r\u00fchm. Ryhm &#8211; on olem, mis esitab r\u00fchma, r\u00fchm kuulub osakonda. Relatsiooniline andmebaasi kuju: Skeemi realisatsioon MySQL vahendiga: CREATE TABLE &#8230;. N\u00e4iteandmed: INSERT INTO &#8230; (1, (2, (3, Andmebaasi skeem MS SQL Server \/v\u00f5i &hellip; <a href=\"https:\/\/merkulova.thkit.ee\/ta\/andmebaasi-skeem\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">Andmebaasi skeem<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/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-185","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/pages\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":13,"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/pages\/185\/revisions"}],"predecessor-version":[{"id":398,"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/pages\/185\/revisions\/398"}],"wp:attachment":[{"href":"https:\/\/merkulova.thkit.ee\/ta\/wp-json\/wp\/v2\/media?parent=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}