ma'lumotlar bazalari texnologiyasi fanidan topshiriqlar

DOCX 24 sahifa 2,4 MB Bepul yuklash

24 sahifa

FaylHub.uz

Telegram orqali yuklab olish

Hajm 2,4 MB

Fayl turi DOCX

Sahifalar 24

Yangilangan Dek 2025

Sahifa ko'rinishi (5 sahifa)

Pastga aylantiring 👇

1 / 24

o‘zbekiston respublikasi oliy va o‘rta-maxsus ta’lim vazirligi sharof rashidov nomidagi samarqand davlat universiteti matematika fakulteti amaliy matematika yo‘nalishi 327 - guruh talabasi lazizbek karimovning ma’lumotlar bazalari texnologiyasi fanidan tayyorlagan mustaqil ishi tekshirdi:e.eshonqulov. samarqand – 2022 1-topshiriq. infologik modelni hosil qilish. 2-topshiriq. er-model hosil qilish. 3-topshiriq. relatsion model hosil qilish. 4-topshiriq. relatsion algebra amallarini qo’llash. 1. users -birlashma amali (𝑨 𝖴 𝑩 yoki 𝑨 union 𝑩) id fio position 10001 karimov lazizbek ziyodulla o’g’li assistent 10002 qarshiboyev alisher abduvali o’g’li assistent a id fio position 10001b karimov lazizbek ziyodulla o’g’li assistent 10003 ergashev nodir ihom o’g’li katta o’qituvchi a b id fio position 10001 karimov lazizbek ziyodulla o’g’li assistent 10002 qarshiboyev alisher abduvali o’g’li assistent 10003 ergashev nodir ihom o’g’li katta o’qituvchi 1. users -kesishma amali ( 𝑨 ∩ 𝑩 yoki 𝑨 intersect 𝑩 ) a b id fio position 10001 karimov lazizbek ziyodulla o’g’li assistent 1. users -ayirma amali ( …

2 / 24

g’li katta o’qituvchi employee munosabatidagi tanlash amali employee [position = “asistent”] id fio position 10001 karimov lazizbek ziyodulla o’g’li assistent 10002 qarshiboyev alisher abduvali o’g’li assistent 1. employee - proyeksiya amali ( a munosabatining proyeksiyasi v, w, z atributlari bilan a[v, w, z] bilan belgilanadi. ) id fio age 10001 karimov lazizbek ziyodulla o’g’li 20 10002 qarshiboyev alisher abduvali o’g’li 25 10003 ergashev nodir ihom o’g’li 37 10004 eshtimerov bobur adham o’g’li 41 10005 abdulkarimov ibrohim sherali o’g’li 28 employee munosabatidagi proyeksiya amali employee [age > 21 ] age 25 37 41 28 1. employee va teacher - ulash amalikanallar employee id fio specialty type salary 10001 karimov lazizbek assistent 5200000 10002 qarshiboyev alisher senior teacher 9800000 10003 ergashev nodir assistent 4150000 10004 eshtimerov bobur assistent 2800000 teacher id department course specialty 10001 applied mathematics 2,3 assistent 10002 math analysis 2 assistent 10003 astyranomy 1, 3 assistent 10004 philosophy 1,2,3,4 …

3 / 24

iq. sqlda ma’lumotlarni manipulyatsiya qilish. 6.1. sql tili orqali jadvallarni hosil qilish. relatsion model(3- topshiriq)da hosil qilingan jadvallarga create operatorini hosil qilish. create table foydalanuvchi ( idfoydalanuvchi int not null primary key, username varchar(30) not null, email varchar(30) null, passwords varchar(15) not null, createtime date null, usertype varchar(5) not null ); create table student ( idstudent int not null primary key, name varchar(20) not null, surname varchar(20) not null, fathername varchar(20) null, sex varchar(1) not null, brithdate date not null, address varchar(50) null, callphone varchar(15) null, course int(1) not null, groups int(3) not null ); 6.2. sql tili orqali jadvallarga yangi ma’lumot qo’shish. relatsion model(3-topshiriq)da hosil qilingan jadvallarga insert operatori orqali har biriga 15 ta dan ma’lumot qo’shing. insert into foydalanuvchi(idfoydalanuvchi,username,email,passwordd,createtime,usertype) values (1,"abrormajidov","abrormajid@gmail.com","1234567890","2018-05-04","user"); insert into foydalanuvchi(idfoydalanuvchi,username,email,passwordd,createtime,usertype) values (2,"lazizbekkarimov","lazizbekkarimov286@gmail.com","1234567890","2020-01-10","user"); insert into foydalanuvchi(idfoydalanuvchi,username,email,passwordd,createtime,usertype) values (3,"dalerjonnorkulov","dalerjonnorkulov@gmail.com","1234567890","2013-07-17","user"); insert into foydalanuvchi(idfoydalanuvchi,username,email,passwordd,createtime,usertype) values (4,"ozodbekrustamov","ozodbekrustamov@gmail.com","1234567890","2015-03-12","user"); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (5, 'ilyse', …

4 / 24

il, passwordd, createtime, usertype) values (7, 'eziechiele', 'egrayland6@myspace.com', '2kvppgd', '2022-06-10', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (8, 'chan', 'cdewire7@dion.ne.jp', 'dgurxqed681j', '2022-03-24', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (9, 'mikey', 'mspyer8@adobe.com', 'wetesu9njt', '2022-11-26', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (10, 'roseann', 'rbilovus9@amazon.com', 'kgx3fucr', '2022-05-18', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (11, 'zak', 'zfiennes0@liveinternet.ru', 'thghak', '2022-09-03', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (12, 'kiel', 'kdongall1@de.vu', 'qabhnapm5', '2022-12-20', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (13, 'rosmunda', 'rmcmonies2@dedecms.com', 'pvtl4460k', '2022-04-01', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (1, 'larry', 'lbortolotti3@telegraph.co.uk', 'funol4mkznbs', '2022-07-06', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (14, 'stirling', 'spamment0@oakley.com', 'jigrnolyyxk', '2022-09-26', 'user'); insert into foydalanuvchi (idfoydalanuvchi, username, email, passwordd, createtime, usertype) values (15, …

5 / 24

e`= "admin" where username = "lazizbekkarimov"; 6.4. sql tili orqali jadvallardagi ma’lumotni o’chirish. relatsion model(3-topshiriq)da hosil qilingan jadvallardagi bittadan ma’lumotni delete operatori orqali o’chirish. delete from `foydalanuvchi` where email = "abrormajid@gmail.com"; 7-topshiriq. sqlda so’rovlar hosil qilish. 7.1-topshiriq. jadvaldan ustunlarni olish. select * from foydalanuvchi; select username,passwordd,usertype from `foydalanuvchi`; 7.2. noyob satrlarni olish select distinct `usertype` from `foydalanuvchi`; 7.3. so’rov natijalarini cheklash select `username`from `foydalanuvchi` limit 7 foydalanuvchi jadvalidagi username ustunidan dastlabki 7 ta qiymatni olish. select `username`from `foydalanuvchi` limit 7 offset 7 foydalanuvchi jadvalidagi username ustunidagi 7 qatordan boshlab 7 ta qiymatni olish. 7.4. so’rovni shartlar asosida cheklash select createtime, username from `foydalanuvchi` where `createtime` > "2022-01-01" foydalanuvchi jadvalidagi createtime ustunidan 2022-01-01 sanadan so’ng ro’yxatdan o’tganlar qiymatni olish. 7.5. yozuvlarni saralash select * from `foydalanuvchi` order by username foydalanuvchilar jadvalini username ustunini o’sish bo’yicha saralash select * from `foydalanuvchi` order by username desc foydalanuvchilar jadvalini username ustunini kamayish bo’yicha saralash …

Ko'proq o'qimoqchimisiz?

Barcha 24 sahifani Telegram orqali bepul yuklab oling.

To'liq faylni yuklab olish

"ma'lumotlar bazalari texnologiyasi fanidan topshiriqlar" haqida

o‘zbekiston respublikasi oliy va o‘rta-maxsus ta’lim vazirligi sharof rashidov nomidagi samarqand davlat universiteti matematika fakulteti amaliy matematika yo‘nalishi 327 - guruh talabasi lazizbek karimovning ma’lumotlar bazalari texnologiyasi fanidan tayyorlagan mustaqil ishi tekshirdi:e.eshonqulov. samarqand – 2022 1-topshiriq. infologik modelni hosil qilish. 2-topshiriq. er-model hosil qilish. 3-topshiriq. relatsion model hosil qilish. 4-topshiriq. relatsion algebra amallarini qo’llash. 1. users -birlashma amali (𝑨 𝖴 𝑩 yoki 𝑨 union 𝑩) id fio position 10001 karimov lazizbek ziyodulla o’g’li assistent 10002 qarshiboyev alisher abduvali o’g’li assistent a id fio position 10001b karimov lazizbek ziyodulla o’g’li assistent 10003 ergashev nodir ihom o’g’li katta o’qituvchi a b id fio positio...

Bu fayl DOCX formatida 24 sahifadan iborat (2,4 MB). "ma'lumotlar bazalari texnologiyasi fanidan topshiriqlar"ni yuklab olish uchun chap tomondagi Telegram tugmasini bosing.

Teglar: ma'lumotlar bazalari texnologiy… DOCX 24 sahifa Bepul yuklash Telegram