ma`lumotlar bazasi ni loyihalash

PPTX 12 sahifa 1,9 MB Bepul yuklash

12 sahifa

FaylHub.uz

Telegram orqali yuklab olish

Hajm 1,9 MB

Fayl turi PPTX

Sahifalar 12

Yangilangan Dek 2025

Sahifa ko'rinishi (5 sahifa)

Pastga aylantiring 👇

1 / 12

muhammad al-xorazmiy nomidagi toshkent axborot texnologoyilari universtiteti kompyuter injenering fakulteti dbm002 guruhi talabasi xolbyev davronning ma`lumotlar bazasi fanidan yozgan mustaqil ishisi muhammad al-xorazmiy nomidagi toshkent axborot texnologoyilari universtiteti kompyuter injenering fakulteti dbm002 guruhi talabasi berdikulov shohruhning ma`lumotlar bazasi fanidan yozgan mustaqil ishisi mavzu: ma`lumotlar bazasini loyihalash. mohiyat – aloqa diagrammasini qurish (er modeli) ma`lumotlar bazasida quyidagi munosabatlar mavjud: 1. birga – bir (1:1)munosabat. a va v ob`ektlar to`plami orasida 1:1 munosabat o`rnatilgan deyiladi, agarda a ob`ektning har bir nusxasiga v ob`ektning bitta nusxasi mos kelsa, va aksincha, v ob`ektning har bir nusxasiga a ob`ektning bitta nusxasi mos kelsa. 2. birga – ko`p (1:n) munosabat. a va v ob`ektlar to`plamida a ob`ektning har bir nusxasiga v ob`ektning bir nechta nusxasi mos kelsa, shu bilan birga v ob`ektning har bir nusxasiga a ob`ektning bittadan ko`p bo`lmagan nusxasi mos kelsa shunday munosabat hosil bo`ladi. 3. ko`pga – bir (n:1) munosabat a va v …

2 / 12

bog`langan to`plamidir. har bir munosabat kompyuterda fayl ko`rinishida tasvirlanadi. mavzu: sql tilida jadvallar yaratish, o‘zgartirish va o‘chirish integer butun son (odatda 10 tagacha qiymatli raqam va ishora). smallint «qisqa butun» (odatda 5 tagacha qiymatli raqam va ishora). decimal(p,q) o‘nli son, p raqam va ishoradan iborat (0 0 va har xil mbbt larda turlicha, lekin 4096 dan kam emas). date maxsus komanda orqali aniqlanuvchi formatdagi sana; sana maydonlari bizning eramizdan oldin bir necha mingyilliklardan boshlanuvchi va bizning eramiz beshinchi-o‘ninchi mingyilligi bilan cheklangan haqiqiy sanalarni o‘z ichiga olishi mumkin. time maxsus komanda orqali aniqlanuvchi formatdagi vaqt (ko‘zda tutilgan bo‘yicha hh.mm.ss). datetime sana va vaqt kombinatsiyasi. money maxsus komanda orqali aniqlanuvchi formatdagi pul birligi. 4 5 6 mavzu: ma’lumotlarni tanlash va ular ustida amallar dml tili so’rovlari: select – amal bajaradigan jadvalimizni tanlash, ekranga chiqarish komandasi. sintaksisi esa quyidagicha: select *from // jadvalni to’liq chiqarish select from // jadval ustunlarini chiqarish insert – …

3 / 12

$g image6.png image7.png image8.png image9.png image10.png @® } public 5 product 6 maker character varying(10) 2 model character varying(50) —4 fa type character varying(50) @® @® & public © public © & laptop ipc } public & code integer & code integer printer 6 model character varying(50) e——- | model character varying(50) >» & code integer {j speed smallint speed smaliint ‘ § model character varying(50) >e— 6 ram smaliint 6 ram smaliint 6] color character(1) 6 hd real 6 hd real fa type character varying(10) j price numeric(12,2) fa cd character varying(10) j price numeric(12,2) j screen smallint 63 price numeric(12,2) f] cawindows\system32\cmd. x bb windows powershell postgres=# postgres=# postgres=# postgres=# postgres=# postgres=# postgres=# postgres=# \l ib spipbxeixy | a4opwetep app-auth postgres utf8 app-my-jwt-practice postgres utf8 app_relationships postgres utf8 atm_app postgres utf8 bazara_net postgres utf8 bfauz postgres utf8 codingbat postgres utf8 computer_db postgres utf8 computer_db_home postgres utf8 lebazar_old postgres …$

4 / 12

russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. russian_russia. 1251 1251 1251 1251 1251 1251 1251 1251 1251 1251 1251 1251 1251 4+eptp bwé€eap =tc/postgres + postgres=ctc/postgrest lebazar=ctc/postgres =c/postgres + postgres=ctc/postgres =c/postgres + postgres=ctc/postgres @ ims x bs pgadmin 4 c a © 127.001 mail.ru pdpit > pr e unit s pgitlab © shohruh - geadmin filey objecty toolsy helpy browser s 2b. q_s dependents § computer_db/postgres@! g1 gh public.laptop/computer_db/postgres@postgresql 13 x > c event triggers & & ay ql) ml. mh @ 8s) ear ay im ym ow ay br vom - a > ‘extensions > foreign data wrappers wy || v | nolimit vj] @| > | wo by 3 8 aw st ¥v glanguages (1) query editor query history query editor query history won ease 1 select * from laptop; 1 select x from public.1 ¥ & schemas (1) 2 2 order …

5 / 12

12 13, 14 15 16 7 18 price 400.00 970.00 600.00 600.00 855.00 367.50 1050.00 850.00 882.00 735.00 1150.00 367.50 873.00 1200.00 367.50 query history messages _ notifications model a code character varying (50) integer 1232 1321 1232 1233 1233 1232 1298 1121 1233 1298 1752 1260 1233 1750 1232 ar wo a w 11 10 12 @ speed 20 10 10 10 20 12 10 500 500 500 500 750 450 600 600 900 350 750 500 800 750 450 32 64 64 64 128 64 64 128 128 32 128 32 128 128 32 9 10 11 a union select price,model,code,hd,l.speed,l.ram from laptop 1) pl ‘inner join product p on p.model=pl.model order by type data output explain price a 4. numeric (12,2) con anak wn a a ror so > 735.00 1150.00 1050.00 950.00 1200.00 970.00 367.50 850.00 882.00 367.50 873.00 850.00 367.50 850.00 400.00 enn an messages …

Ko'proq o'qimoqchimisiz?

Barcha 12 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"ma`lumotlar bazasi ni loyihalash" haqida

muhammad al-xorazmiy nomidagi toshkent axborot texnologoyilari universtiteti kompyuter injenering fakulteti dbm002 guruhi talabasi xolbyev davronning ma`lumotlar bazasi fanidan yozgan mustaqil ishisi muhammad al-xorazmiy nomidagi toshkent axborot texnologoyilari universtiteti kompyuter injenering fakulteti dbm002 guruhi talabasi berdikulov shohruhning ma`lumotlar bazasi fanidan yozgan mustaqil ishisi mavzu: ma`lumotlar bazasini loyihalash. mohiyat – aloqa diagrammasini qurish (er modeli) ma`lumotlar bazasida quyidagi munosabatlar mavjud: 1. birga – bir (1:1)munosabat. a va v ob`ektlar to`plami orasida 1:1 munosabat o`rnatilgan deyiladi, agarda a ob`ektning har bir nusxasiga v ob`ektning bitta nusxasi mos kelsa, va aksincha, v ob`ektning har bir nusxasiga a ob`ektning bitta nusxasi mos kels...

Bu fayl PPTX formatida 12 sahifadan iborat (1,9 MB). "ma`lumotlar bazasi ni loyihalash"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: ma`lumotlar bazasi ni loyihalash PPTX 12 sahifa Bepul yuklash Telegram

ma`lumotlar bazasi ni loyihalash

Sahifa ko'rinishi (5 sahifa)

Ko'proq o'qimoqchimisiz?

"ma`lumotlar bazasi ni loyihalash" haqida

O'xshash fayllar