Mmmmmmmmmmmmmm

ID

1.Ma’lumotlar bazasini loyihalash, mohiyat – aloqa diagrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalashni o’rganish.

FISH

Xodim

Lavozim
mmmmmmmmmmmmmm

Tel.raqami

Ish vaqti

ID

Obunachi

FISH

Tel.raqami

Olingan kitoblar ro’yxati

KUTUBXONA

ID

Rasta

Nomi

Kitob turlari

ID





Turi



Kitob

Nomi





Ishlab chiqarilgan sana



Joylashuv

2.MYSQL tilida jadvallar yaratish, o’zgartirish va o’chirishni o’rganish.

create database kutubxona;

use kutubxona;
create table xodim(
->id int not null primary key auto_increment,
->FISH varchar(64) not null,
->Lavozim varchar(32) not null,
->tel int(16) not null,
->ish_vaqti varchar(32) not null );
mysql> insert into xodim(FISH, lavozim, tel, ish_vaqti)
values('Arslonbek Abdumannonov', 'rektor', '12345671', '08:00dan 17:00gacha');
mysql> insert into xodim(FISH, lavozim, tel, ish_vaqti)
values('Aslolbek Abdumannonov', 'drektor', '12345672', '08:00dan 17:00gacha');
mysql> insert into xodim(FISH, lavozim, tel, ish_vaqti)
values('Alibek Abdumannonov', 'drektor', '12345673', '08:00dan 17:00gacha');
mysql> insert into xodim(FISH, lavozim, tel, ish_vaqti)
values('Oybek Abdumannonov', 'qoravul', '12345674', '08:00dan 17:00gacha');
mysql> select * from xodim;

create table obunachi(

-> id int not null primary key auto_increment,
-> FISH varchar(64) not null,
-> tel_raqami int(16) not null,
-> Olingan_kitoblar_royxati varchar(64) not null );
mysql> insert into obunachi(FISH, tel_raqami, Olingan_kitoblar_royxati) val
ues('Ali Olimov', '12345675', 'Hamsa');
mysql> insert into obunachi(FISH, tel_raqami, Olingan_kitoblar_royxati) values('Akbar Olimov','12345676','Hamsa');
mysql> insert into obunachi(FISH, tel_raqami, Olingan_kitoblar_royxati) values('Akram Olimov','12345677','Tibbiyot etikasi');
mysql> select * from obunachi;

create table rasta(
-> id int not null primary key auto_increment,
-> Nomi varchar(32) not null,
-> Kitob_turlari varchar(32) not null );
mysql> insert into rasta(Nomi,Kitob_turlari) values('rasta_a','tabiiy');
mysql> insert into rasta(Nomi,Kitob_turlari) values('rasta_b','ilmiy');
mysql> insert into rasta(Nomi,Kitob_turlari) values('rasta_c','falsafiy');
mysql> select * from rasta;

create table kitob(
-> id int not null primary key auto_increment,
-> turi varchar(32) not null,
-> nomi varchar(64) not null,
-> ishlab_chiqarilgan_sana varchar(32) not null,
-> joylashuv varchar(32) not null );
mysql> insert into kitob(turi, nomi,ishlab_chiqarilgan_sana,joylashuv) values('tabiiy','fizika','10.10.2020','rasta_a');
mysql> insert into kitob(turi, nomi,ishlab_chiqarilgan_sana,joylashuv) values('ilmiy','matematika','10.01.2020','rasta_b');
mysql> insert into kitob(turi, nomi,ishlab_chiqarilgan_sana,joylashuv) values('falsafiy','falsafa','01.01.2020','rasta_c');

mysql> select * from kitob;

mysql> show tables;

1. 
   AND, OR, NOT, IN, BETWEEN, LIKE, WHERE, HAVING, , Group by va Order by operatorlaridan foydalanib, har bir operatorga 2 tadan misol keltiring.
   

mysql> use kutubxona;

mysql> show tables ;

mysql> select * from xodim;

mysql> select * from xodim where id=1 or id=3;

mysql> select * from xodim where lavozim='rektor' or lavozim='drektor';

mysql> select * from xodim where lavozim='rektor' and id=1;

mysql> select * from xodim where tel=12345671 and ish_vaqti='08:00dan 17:00gacha';

mysql> select * from xodim where not tel=12345671;

mysql> select * from obunachi;

mysql> select * from obunachi where tel_raqami in(12345675,12345676);

mysql> select * from obunachi where olingan_kitoblar_royxati in('Tibbiyot etikasi');

mysql>select * from obunachi where id between 1and 3 ;

mysql> select * from xodim where id between 1 and 4;

mysql> select * from obunachi where id having id>2;

mysql> select * from obunachi where id having id=2;
mysql> select * from obunachi where id having id<2;
mysql> select * from obunachi where id having id<=2;

mysql>select FISH from xodim order by FISH ASC;

mysql>select FISH from xodim order by FISH DESC;

mysql>select FISH from xodim group by FISH ;

mysql>select nomi from kitob group by nomi;

mysql>select nomi as yonalish from kitob group by nomi;