{"id":291,"date":"2024-02-01T08:49:38","date_gmt":"2024-02-01T06:49:38","guid":{"rendered":"https:\/\/vladislavkudr.wordpress.com\/?page_id=291"},"modified":"2024-10-14T07:00:30","modified_gmt":"2024-10-14T07:00:30","slug":"databases","status":"publish","type":"page","link":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/databases\/","title":{"rendered":"Databases"},"content":{"rendered":"\n

Milleks on vaja andmebaas?
— Andmete salvestamine, sailitamine ja korrastamine<\/p>\n\n\n\n

— Andmebaas = AB – andmete korrstatud kogum<\/p>\n\n\n\n

— Andmete korrastamiseks on vaja andmebaasi haldamise tarkvara (\u0421\u0423\u0411\u0414 – \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 – MS SQL Server, XAMPP\/localhost\/phpmyAdmin, MS Access)<\/p>\n\n\n\n

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

Text<\/td>Number<\/td>Kuupaeva\/Loogika<\/td><\/tr>
VARCHAR(255)
Text
CHAR(10)
CHARACTER(20)
Naited: nimi, isikukood, telefon, kirjeldus<\/td>		INT
SMALLINT
BITE
Numeric(5,2)
Decimal(5,2) – \u0434\u0435\u0441\u044f\u0442\u0438\u0447\u043d\u043e\u0435 \u0447\u0438\u0441\u043b\u043e, \u0433\u0434\u0435 2 – \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0437\u043d\u0430\u043a\u043e\u0432 \u043f\u043e\u0441\u043b\u0435 \u0437\u0430\u043f\u044f\u0442\u043e\u0439, \u0430 5 \u0432\u0441\u0435\u0433\u043e \u0437\u043d\u0430\u043a\u043e\u0432
Counter – \u0441\u0447\u0451\u0442\u0447\u0438\u043a
Naited: palk, vanus, pikkus, kaal jne<\/td>		date\/time
date
time
INTERVAL – \u0434\u043b\u044f \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043d\u0442\u0435\u0440\u0432\u0430\u043b\u0430
\u043b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0438\u0439 – BOOL, BOOLEAN, BIT, Yes\/No, True\/False<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u0442\u0430\u0431\u043b\u0438\u0446\u0430 – tabel<\/p>\n\n\n\n

\u043f\u043e\u043b\u0435=\u0441\u0442\u043e\u043b\u0431\u0435\u0446 – vali=veerg<\/p>\n\n\n\n

\u0437\u0430\u043f\u0438\u0441\u044c=\u0441\u0442\u0440\u043e\u043a\u0430 – kirje=rida<\/p>\n\n\n\n

PIIRANGUD- \u041e\u0433\u0440\u0430\u043d\u0438\u0447\u0435\u043d\u0438\u044f<\/p>\n\n\n\n

    \n
  1. PRIMARY KEY – \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 – primaarne voti – \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u0438\u0434\u0435\u043d\u0442\u0438\u0444\u0438\u0446\u0438\u0440\u0443\u0435\u0442 \u0441\u0440\u043e\u043a\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u043a\u0430\u0436\u0434\u043e\u0439 \u0441\u0442\u0440\u043e\u0447\u043a\u0435 \u043f\u0440\u0438\u0441\u0432\u0430\u0438\u0432\u0430\u0435\u0442 \u0441\u0432\u043e\u0439 \u043d\u043e\u043c\u0435\u0440.<\/li>\n\n\n\n
  2. FOREIGN KEY – \u0432\u043d\u0435\u0448\u043d\u0438\u0439\/\u0432\u0442\u043e\u0440\u0438\u0447\u043d\u044b\u0439 \u043a\u043b\u044e\u0447 – \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442 \u0432\u043d\u0435\u0448\u043d\u0438\u0439 \u043a\u043b\u044e\u0447 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0437\u0430\u0434\u0430\u0451\u0442 \u0441\u0432\u044f\u0437\u044c \u043c\u0435\u0436\u0434\u0443 \u0434\u0432\u0443\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 (\u0441\u0432\u044f\u0437\u044c \u0441 \u043f\u0435\u0440\u0432\u0438\u0447\u043d\u044b\u043c \u043a\u043b\u044e\u0447\u043e\u043c \u0434\u0440\u0443\u0433\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b)<\/li>\n\n\n\n
  3. UNIQUE – \u043d\u0435\u043f\u043e\u0432\u0442\u043e\u0440\u044f\u044e\u0449\u0435\u0435\u0441\u044f \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435<\/li>\n\n\n\n
  4. NOT NULL – \u043d\u0435\u043f\u0443\u0441\u0442\u043e\u0435 \u043f\u043e\u043b\u0435<\/li>\n\n\n\n
  5. CHECK – ?<\/li>\n<\/ol>\n\n\n\n

    SQL Server managment Stuudio – (localdb)\\mssqllocaldb<\/p>\n\n\n

    \n--Taabeli loomine\nCREATE TABLE opilane(\nopilaneID int Primary Key identity(1,1),\neesnimi varchar(50),\nperenimi varchar(50),\nsynniaeg date,\nopilaskodu bit);\nSELECT * FROM opilane;\n--andmete lisamine tabelisse\nINSERT INTO opilane(eesnimi, perenimi, synniaeg,opilaskodu)\nVALUES ('Seva','Tsarev', '2007-01-02', 1),\n('Gleb','Sotsov', '2007-01-02', 1),\n('Vladislav','Kudriashev', '2007-25-02', 1),\n('Martin','Sild', '2007-01-02', 1),\n('Kirill','Sats', '2007-01-02', 1);\nSELECT * FROM opilane;\nDELETE FROM opilane WHERE opilaneID=1\n<\/pre><\/div>\n\n
    \nCREATE TABLE ryhm(\nryhmID int not null primary key identity(1,1),\nryhmNimi char(8) unique);\nSelect * from ryhm;\n--lisamine\nINSERT INTO ryhm(ryhmNimi)\nVALUES ('TARpv21'),\n('TARpv22'),\n('TARpv23');\nSelect * from ryhm;\nSelect * from opilane;\n--lisada uus veerg tabellisse opilane\nALTER TABLE opilane ADD ryhmID int;\n--taidame ryhmID tabelis opilane\nUPDATE opilane SET ryhmID=1;\n--Foreign Key\nALTER TABLE opilane ADD foreign key\n(ryhmID) references ryhm(ryhmID);\n<\/pre><\/div>\n\n
    \nCREATE TABLE \u0420indamine(\nhindamineID int not null primary key identity(1,1),\nopilaneID int,\naine varchar(50),\nhinne int);\nselect * from Hindamine;\nselect * from opilane;\nALTER TABLE Hindamine ADD foreign key;\n(opilaneID) references opilane(opilaneID);\nINSERT INTO Hindamine(opilaneID, aine, hinne)\nVALUES (1, 'matemaatika', 5),\nVALUES (2, 'keemia', 3),\nVALUES (3, 'matemaatika', 2),\nVALUES (4, 'fuusika', 4),\nVALUES (5, 'programeerimine', 3)\n<\/pre><\/div>\n\n\n
    Kodut\u00f6\u00f6<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
    Milleks on vaja andmebaas?— Andmete salvestamine, sailitamine ja korrastamine — Andmebaas = AB – andmete korrstatud kogum — Andmete korrastamiseks on vaja andmebaasi haldamise tarkvara (\u0421\u0423\u0411\u0414 – \u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 – MS SQL Server, XAMPP\/localhost\/phpmyAdmin, MS Access) Andmetuubid Text Number Kuupaeva\/Loogika VARCHAR(255)TextCHAR(10)CHARACTER(20)Naited: nimi, isikukood, telefon, kirjeldus INTSMALLINTBITENumeric(5,2)Decimal(5,2) – \u0434\u0435\u0441\u044f\u0442\u0438\u0447\u043d\u043e\u0435 \u0447\u0438\u0441\u043b\u043e, \u0433\u0434\u0435 2 – \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e […]<\/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-291","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/pages\/291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":1,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/pages\/291\/revisions"}],"predecessor-version":[{"id":1182,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/pages\/291\/revisions\/1182"}],"wp:attachment":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/en-us\/wp-json\/wp\/v2\/media?parent=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}