{"id":1386,"date":"2024-01-31T07:17:06","date_gmt":"2024-01-31T07:17:06","guid":{"rendered":"https:\/\/darjaportnova23.thkit.ee\/wp\/?page_id=1386"},"modified":"2024-04-02T15:49:39","modified_gmt":"2024-04-02T15:49:39","slug":"andmebaasisusteemide-alused","status":"publish","type":"page","link":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/","title":{"rendered":"Fundamentals of database systems"},"content":{"rendered":"\n<div class=\"wp-block-query alignwide is-layout-flow wp-block-query-is-layout-flow\"><ul class=\"wp-block-post-template is-layout-flow wp-block-post-template-is-layout-flow\"><li class=\"wp-block-post post-1477 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/task-in-xampp-sql\/\" target=\"_blank\" >XAMPP SQL &#8211; Routines<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">1.1 Adding data (INSERT) into any arbitrary table from the cinema database: The first query adds information about the director to the table &#8216;rezisoor&#8217;. The second query adds informarion about the movie to the table &#8216;film&#8217; (movie title, genre ID, language, movie durarion, director ID, movie type). 1.2 Deleting records in the \u017eanr table based<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/task-in-xampp-sql\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1624 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/trigger-sql\/\" target=\"_blank\" >Trigger SQL<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">New query Concat()- \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u0437 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u043f\u043e\u043b\u0435\u0439<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/trigger-sql\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1988 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/task-adding-user-permissions-m-sql-servis-ms\/\" target=\"_blank\" >TASK &#8211; Adding User Permissions &#8211; M SQL Servis MS\/ XAMPP<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">Security&#8212; Login&#8212;New Login Roles&#8212;Database Roles&#8212;New Database roles Kontroll: XAMPP<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/task-adding-user-permissions-m-sql-servis-ms\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1412 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/sql-select\/\" target=\"_blank\" >SQL database<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">In new query: In new query: &#8211;5. \u0410\u0433\u0440\u0435\u0433\u0430\u0442\u043d\u044b\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438SUM(), AVG(), MIN(), MAX(), COUNT() In new query The last one phpMyAdmin: Task: \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0441\u0442\u043e\u043b\u0431\u0435\u0446 synnilinn \u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 Haapsalu \u043d\u0430\u0447\u0438\u043d\u0430\u044f \u0441 &#8220;S&#8221; Task: \u041e\u0431\u043d\u043e\u0432\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 laps \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0432\u0441\u0435\u043c \u0434\u0435\u0442\u044f\u043c 2000\u0433\u043e\u0434\u0430 \u0440\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0440\u043e\u0441\u0442 158. Task: \u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0439. \u0412\u044b\u0432\u0435\u0441\u0442\u0438 \u0432\u0441\u0435 \u0438\u043c\u0435\u043d\u0430 \u0434\u0435\u0442\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0440\u043e\u0434\u0438\u043b\u0438\u0441\u044c \u0432 2000 \u0433\u043e\u0434\u0443 \u0438<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/sql-select\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1591 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/select-query-ms-sql-servermanagementstudio\/\" target=\"_blank\" >SELECT query (MS SQL ServerManagementStudio)<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">https:\/\/moodle.edu.ee\/pluginfile.php\/1213077\/mod_resource\/content\/1\/ru\/index_ru.html SELECT laused 2 tabelite p\u00f5hjal \u041f\u043e\u043a\u0430\u0436\u0438\u0442\u0435 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u0441\u0442\u0440\u0430\u043d \u043a\u043e\u043d\u0442\u0438\u043d\u0435\u043d\u0442\u0430 \u0415\u0432\u0440\u043e\u043f\u0430, \u0438\u0445 \u0441\u0442\u043e\u043b\u0438\u0446\u044b, \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u043d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u044f \u043f\u0440\u043e\u0436\u0438\u0432\u0430\u044e\u0449\u0435\u0433\u043e \u0432 \u0441\u0442\u043e\u043b\u0438\u0446\u0435, \u043e\u0442\u0441\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u0432 \u043f\u043e\u0440\u044f\u0434\u043a\u0435 \u0443\u0431\u044b\u0432\u0430\u043d\u0438\u044f \u043d\u0430\u0441\u0435\u043b\u0435\u043d\u0438\u044f: &#8211; \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u044f \u0442\u043e\u043b\u044c\u043a\u043e \u0441\u0442\u0440\u0430\u043d\u044b, \u0438\u043c\u0435\u044e\u0449\u0438\u0435 \u0441\u0442\u043e\u043b\u0438\u0446\u0443\u00a0(\u0441\u043c.\u043e\u0442\u0432\u0435\u0442) &#8211; \u0443\u0447\u0438\u0442\u044b\u0432\u0430\u044f \u0432\u0441\u0435 \u0441\u0442\u0440\u0430\u043d\u044b\u00a0(\u0441\u043c.\u043e\u0442\u0432\u0435\u0442) \u041f\u043e\u043a\u0430\u0436\u0438\u0442\u0435 \u0441\u0442\u0440\u0430\u043d\u044b, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u0440\u0430\u043d\u044b \u0438 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0441\u0442\u043e\u043b\u0438\u0446\u044b \u0441\u043e\u0432\u043f\u0430\u0434\u0430\u044e\u0442&nbsp;(\u0441\u043c.\u043e\u0442\u0432\u0435\u0442) \u041d\u0430\u0439\u0434\u0438\u0442\u0435 \u0433\u043e\u0440\u043e\u0434\u0430, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0438\u043c\u0435\u044e\u0442 \u043e\u0434\u0438\u043d\u0430\u043a\u043e\u0432\u044b\u0435 \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u044f \u0438 \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u0432 \u043e\u0434\u043d\u043e\u0439 \u0441\u0442\u0440\u0430\u043d\u0435.&nbsp;(\u0441\u043c.\u043e\u0442\u0432\u0435\u0442) \u041f\u043e\u043a\u0430\u0436\u0438\u0442\u0435,<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/select-query-ms-sql-servermanagementstudio\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1461 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/procedures-in-sql\/\" target=\"_blank\" >Routines in SQL<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">IN Microsoft SQL Server Managment Studio Creating a procedure (In new Query): Calling a procedure: Deleting a procedure: The user enter the first letter of the school, and then all the schools data is displayed: The user enters only table values and then the table is filled: Deletes one record or row by ID: Request<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/procedures-in-sql\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1551 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/ms-access-database\/\" target=\"_blank\" >MS ACCESS Database<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">Andmebaasiriisad=&gt;Seosed Loo=>Tabeli kujundus (Primary key\/Foreign key) Loo=&gt;Vormiviisard<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/ms-access-database\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-2952 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-arvestustoo-cybersport\/\" target=\"_blank\" >DB ArvestusT\u00f6\u00f6: CyberSport<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">Microsoft SQL Server Management Studio Adding data Deleting data XAMPP Adding data Deleting data<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-arvestustoo-cybersport\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-1903 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-task-in-xampp-test-ja-test-kuupaev\/\" target=\"_blank\" >DB &#8211; Task in XAMPP (Test ja Test kuup\u00e4ev)<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\"><\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-task-in-xampp-test-ja-test-kuupaev\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><li class=\"wp-block-post post-2213 page type-page status-publish hentry\">\n<h2 class=\"wp-block-post-title\"><a href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-random-adding-data-to-the-database\/\" target=\"_blank\" >DB &#8211; Random adding data to the database<\/a><\/h2>\n\n<div class=\"wp-block-post-excerpt\"><p class=\"wp-block-post-excerpt__excerpt\">Using SELECT, UPDATE, DELETE statements Adding your own table Use https:\/\/www.mockaroo.com to generate at least 100 pieces of data in the table Procedures, Triggers, Users Create a user named director who can create triggers (at least 2) and monitor their work (the director can see the table log, but cannot add or delete anything to<\/p><p class=\"wp-block-post-excerpt__more-text\"><a class=\"wp-block-post-excerpt__more-link\" href=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/db-random-adding-data-to-the-database\/\"><a>Read more&#8230;<\/a><\/a><\/p><\/div>\n<\/li><\/ul><\/div>\n\n\n\n<p>A table is a database object that stores data in the form of rows and columns. The structure of a table is defined by the columns it contains.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL statements<\/h2>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>DDL &#8211; Data Definition Language (CREATE TABLE, ALTER TABLE)<\/summary>\n<ul class=\"wp-block-list\">\n<li>CREATE TABLE &#8211; Creating a table\n<ul class=\"wp-block-list\">\n<li><strong>Table name:<\/strong> <em>The names of tables must be unique within the owner&#8217;s context. In other words, two tables with the same name cannot belong to the same owner, but another user may have a table with the same name.<\/em><\/li>\n\n\n\n<li><strong>Column names (fields):<\/strong> <em>Column names are unique within a table. Column names adhere to standard rules for choosing identifiers and consist of letters, numbers, and special characters.<\/em><\/li>\n\n\n\n<li><strong>Data types:<\/strong> \n<ul class=\"wp-block-list\">\n<li>Character (string) types:\n<ul class=\"wp-block-list\">\n<li>CHAR(n) or CHARACTER(n) &#8211; <em>default length: 1 and max length: 255<\/em><\/li>\n\n\n\n<li>CHARACTER VARYING(n) or CHAR VARYING(n)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Numeric types:\n<ul class=\"wp-block-list\">\n<li>SMALLINT, INT2, INTEGER, INT, INT4, BIGINT, INT8<\/li>\n\n\n\n<li>REAL, FLOAT4, DOUBLE PRECISION, FLOAT8, FLOAT<\/li>\n\n\n\n<li>NUMERIC(p,s), DECIMAL (p,s)<\/li>\n\n\n\n<li>MONEY<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Boolean and binary types: BOOLEAN, BOOL, BIT<\/li>\n\n\n\n<li>Date and time type: DATE, TIME, INTERVAL, DATETIME<\/li>\n\n\n\n<li>Data types in MS Access SQL: \n<ul class=\"wp-block-list\">\n<li>TEXT(n) &#8211; <em>Variable-length text, maximum length of n characters<\/em><\/li>\n\n\n\n<li>MEMO &#8211; <em>Text, for volume exceeding 255 characters <\/em><\/li>\n\n\n\n<li>BYTE, INTEGER, LONG &#8211; <em>Integer numbers <\/em><\/li>\n\n\n\n<li>COUNTER &#8211; <em>Counter, integer numbers <\/em><\/li>\n\n\n\n<li>SINGLE, DOUBLE, CURRENCY &#8211; <em>Floating-point numbers <\/em><\/li>\n\n\n\n<li>DATETIME &#8211; <em>Date and time <\/em><\/li>\n\n\n\n<li>YESNO &#8211;<em> Logical type <\/em><\/li>\n\n\n\n<li>LONGBINARY &#8211; <em>OleObject, binary type<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Memory size<\/strong><\/li>\n\n\n\n<li><strong>Mandatory columns<\/strong><\/li>\n\n\n\n<li><strong>Primary key columns<\/strong><\/li>\n\n\n\n<li><strong>Foreign key columns<\/strong><\/li>\n\n\n\n<li><strong>Constraints<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>ALTER TABLE &#8211; Modifying the structure of a table<\/li>\n\n\n\n<li>DROP TABLE &#8211; Deleting a table<\/li>\n\n\n\n<li>CREATE INDEX &#8211; Creating an index<\/li>\n\n\n\n<li>ALTER INDEX &#8211; Modifying an index<\/li>\n\n\n\n<li>DROP INDEX &#8211; Deleting an index<\/li>\n<\/ul>\n<\/details>\n\n\n\n<details class=\"wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>DML -Data Manipulation Language (INSERT INTO, DELETE FROM, UPDATE)<\/summary>\n<p><\/p>\n<\/details>\n\n\n\n<h4 class=\"wp-block-heading\">Table creation (DDL)<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE toode(\n\ttoodeID int primary key AUTO_INCREMENT,\n    toodeNimetus varchar(50),\n    toodeHind decimal(5, 2),\n    v_kuupaev date,\n\tkas_olemas bit\n);\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">Adding data to the table (DML)<\/h4>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nINSERT INTO toode(toodeNimetus, toodeHind, kas_olemas, v_kuupaev)\nVALUES (&#039;piim Alma&#039;, 1.50, 1, &#039;2024-01-31&#039;);\nSELECT * FROM toode;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE `suhhanovabaas`.`tellimus` (`tellimusID` INT NOT NULL AUTO_INCREMENT , `tellimuseKuupaev` DATE NOT NULL , `toodeID` INT NOT NULL , `klient` VARCHAR(50) NOT NULL , PRIMARY KEY (`tellimusID`)) ENGINE = InnoDB; \n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">Constraints &#8211; Piirangud (\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f)<\/h4>\n\n\n\n<p>PRIMARY KEY &#8211; The column value is unique<\/p>\n\n\n\n<p>FORIGEIN KEY &#8211; The column uses a value from a related table.<\/p>\n\n\n\n<p>NOT NULL &#8211; Non-empty value<\/p>\n\n\n\n<p>UNIQUE &#8211; Unique values<\/p>\n\n\n\n<p>CHECK &#8211; Selection of certain values<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TEST<\/h2>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image alignwide size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"401\" data-id=\"1391\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-1024x401.png\" alt=\"\" class=\"wp-image-1391\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-1024x401.png 1024w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-300x117.png 300w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-768x301.png 768w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1.png 1078w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img decoding=\"async\" width=\"432\" height=\"280\" data-id=\"1390\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt.png\" alt=\"\" class=\"wp-image-1390\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt.png 432w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-300x194.png 300w\" sizes=\"(max-width: 432px) 100vw, 432px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image alignwide size-large\"><img decoding=\"async\" width=\"1024\" height=\"363\" data-id=\"1392\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-2-1024x363.png\" alt=\"\" class=\"wp-image-1392\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-2-1024x363.png 1024w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-2-300x106.png 300w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-2-768x272.png 768w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-2.png 1077w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image alignwide size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"57\" data-id=\"1393\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-3.png\" alt=\"\" class=\"wp-image-1393\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-3.png 756w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-3-300x23.png 300w\" sizes=\"(max-width: 756px) 100vw, 756px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"46\" data-id=\"1394\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-4.png\" alt=\"\" class=\"wp-image-1394\" style=\"width:650px;height:auto\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-4.png 369w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-4-300x37.png 300w\" sizes=\"(max-width: 369px) 100vw, 369px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image alignwide size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"615\" height=\"302\" data-id=\"1395\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-5.png\" alt=\"\" class=\"wp-image-1395\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-5.png 615w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-5-300x147.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/figure>\n<\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE table Product(\n    idProduct int primary key AUTO_INCREMENT,\n    ProductName varchar(50),\n    idCategory int,\n    Price decimal(6, 2),\n    FOREIGN key(idCategory) REFERENCES category(idCategory)\n);\n\ncreate table customer(\n    idCustomer int PRIMARY KEY AUTO_INCREMENT,\n    nameCustomer varchar(100) UNIQUE,\n    contactCustomer varchar(50)\n);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\ninsert into product(ProductName, idCategory, Price)\nVALUES (&#039;boots&#039;, 3, 100.99)\n\ninsert into Sale(idProduct, Count_, DateOfSale)\nvalues(1,200,&#039;2024-01-31&#039;),(3,200,&#039;2024-01-31&#039;),(4,100,&#039;2024-01-31&#039;),(3,250,&#039;2024-01-31&#039;),(3,57,&#039;2024-01-31&#039;);\n\ninsert into customer(nameCustomer, contactCustomer)\nvalues(&#039;Marko&#039;, 55614815&#039;);\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TABLE sale ADD units char(5);\n\nalter table sale add FOREIGN KEY(idCustomer) REFERENCES customer(idCustomer)\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nupdate sale set idCustomer=1;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image alignwide size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"778\" height=\"597\" src=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-6.png\" alt=\"\" class=\"wp-image-1398\" srcset=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-6.png 778w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-6-300x230.png 300w, https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-6-768x589.png 768w\" sizes=\"(max-width: 778px) 100vw, 778px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A table is a database object that stores data in the form of rows and columns. The structure of a table is defined by the columns it contains. SQL statements Table creation (DDL) Adding data to the table (DML) Constraints &#8211; Piirangud (\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f) PRIMARY KEY &#8211; The column value is unique FORIGEIN KEY &#8211; The [&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-1386","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fundamentals of database systems - Darja Suhhanova (Portnova) - 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:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fundamentals of database systems - Darja Suhhanova (Portnova) - Portfolio\" \/>\n<meta property=\"og:description\" content=\"A table is a database object that stores data in the form of rows and columns. The structure of a table is defined by the columns it contains. SQL statements Table creation (DDL) Adding data to the table (DML) Constraints &#8211; Piirangud (\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f) PRIMARY KEY &#8211; The column value is unique FORIGEIN KEY &#8211; The [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/\" \/>\n<meta property=\"og:site_name\" content=\"Darja Suhhanova (Portnova) - Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-02T15:49:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-1024x401.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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/\",\"name\":\"Fundamentals of database systems - Darja Suhhanova (Portnova) - Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/pilt-1-1024x401.png\",\"datePublished\":\"2024-01-31T07:17:06+00:00\",\"dateModified\":\"2024-04-02T15:49:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/#primaryimage\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/pilt-1.png\",\"contentUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/pilt-1.png\",\"width\":1078,\"height\":422},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/andmebaasisusteemide-alused\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fundamentals of database systems\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\",\"name\":\"Darja Suhhanova (Portnova) - Portfolio\",\"description\":\"Junior Software Developer\",\"publisher\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Darja Suhhanova (Portnova) - Portfolio\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/logoDP-7.png\",\"contentUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/logoDP-7.png\",\"width\":551,\"height\":568,\"caption\":\"Darja Suhhanova (Portnova) - Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fundamentals of database systems - Darja Suhhanova (Portnova) - 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:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/","og_locale":"en_US","og_type":"article","og_title":"Fundamentals of database systems - Darja Suhhanova (Portnova) - Portfolio","og_description":"A table is a database object that stores data in the form of rows and columns. The structure of a table is defined by the columns it contains. SQL statements Table creation (DDL) Adding data to the table (DML) Constraints &#8211; Piirangud (\u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f) PRIMARY KEY &#8211; The column value is unique FORIGEIN KEY &#8211; The [&hellip;]","og_url":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/","og_site_name":"Darja Suhhanova (Portnova) - Portfolio","article_modified_time":"2024-04-02T15:49:39+00:00","og_image":[{"url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-1024x401.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/","name":"Fundamentals of database systems - Darja Suhhanova (Portnova) - Portfolio","isPartOf":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/#primaryimage"},"image":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/#primaryimage"},"thumbnailUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1-1024x401.png","datePublished":"2024-01-31T07:17:06+00:00","dateModified":"2024-04-02T15:49:39+00:00","breadcrumb":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/#primaryimage","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1.png","contentUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/01\/pilt-1.png","width":1078,"height":422},{"@type":"BreadcrumbList","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/andmebaasisusteemide-alused\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/darjaportnova23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Fundamentals of database systems"}]},{"@type":"WebSite","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#website","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/","name":"Darja Suhhanova (Portnova) - Portfolio","description":"Junior Software Developer","publisher":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/darjaportnova23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#organization","name":"Darja Suhhanova (Portnova) - Portfolio","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2023\/11\/logoDP-7.png","contentUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2023\/11\/logoDP-7.png","width":551,"height":568,"caption":"Darja Suhhanova (Portnova) - Portfolio"},"image":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1386"}],"version-history":[{"count":18,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1386\/revisions"}],"predecessor-version":[{"id":2165,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1386\/revisions\/2165"}],"wp:attachment":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}