Mavzu: Ma’lumotlar bazasini loyixalash. Ma’lumotlar bazasi dasturlarini o’rnatish va sozlash. Moxiyat aloqa diogrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalash

1. 
   Amaliy mashg’ulot
   

Mavzu: Ma’lumotlar bazasini loyixalash. Ma’lumotlar bazasi dasturlarini o’rnatish va sozlash. Moxiyat aloqa diogrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalash.

Maqsad: MySQL muxitida ma’lumotlar bazasini loxalashni o’rganish. Relyatsion ma’lumotlar tuzish.

talabalar
id	Familyasi ismi	Tugilgan sana	Manzili	Guruh_id
1	Sodiqov Diyorbek	03.04.2001	Farg’ona	1

Talabalar
id	Guruh nomi	Primary key
Familyasi ismi	Varchae (50)
Tugilgan sana	Date
Manzili	Varchae (50)
Guruh_id	Int	Fk guruh

guruhlar
Id	Guruh nomi	O’qituvchi_id
1	710-21	2

guruhlar
Id	int	pk
guruh nomi	Varchae (50)
O’qituvchi_id	int	Fk guruh

O’qituvchi
Id	int	pk
Familyasi ismi	Varchae (50)

O’qituvchi
id	Familyasi ismi
1	Pulatova G

Xulosa
Men bu amaliyot ishni bajarish davomida ma’lumotlar bazasini loyihalashni va MySql muhitini o’rnatish va sozlashni o’rgandim. Kompyuter injiringi fakulteti kompyuter injineringi yo’nalishi guruhla talabar o’qituvchilar jadvalini loyihsini tuzishni o’rgandim.


2-Amaliy mashg’ulot
Mavzu: Ma’lumotlar bazasini yaratish. SQL tilida jadval yaratish, o’zgartirish va o’chirish. Ma’lumotlar tanlash va ular ustida amallar. AND, OR, NOT mantiqiy standart so’zlardan foydalanish. Ma’lumotlarni saralash. Where standart so’zidan foydalanish.


Maqsad: Jadvalr ustidda amalar. Ma’lumotni saqlash . AND , OR , NOT kodlarini ishlatish.
Mehmonxona
Kodlar
mysql> create database mehmonxona;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;

+-----------------------+
| Database |
+-----------------------+
| information_schema |
| ehtiyot_qismlari |
| idora |
| kutubxona |
| lombard |
| mashinalar |
| masulyatni_taqsimlash |
| mehmonxona |
| mysql |
| sayohat_kompaniyasi |
| sugurta |
| test |
+-----------------------+
12 rows in set (0.00 sec)

mysql> use mehmonxona;

Database changed
mysql> create table mijozlar(
-> id int auto_increment primary key,
-> fam varchar(40),
-> ism varchar(40),
-> pasport varchar(40),
-> izoh text);
Query OK, 0 rows affected (0.01 sec)

mysql> create table xonalar(

-> id int auto_increment primary key,
-> soni int,
-> odamlar_soni int,
-> qulaylik varchar(30),
-> narxi int);
Query OK, 0 rows affected (0.01 sec)

mysql> create table xisob_kitob(

-> id int auto_increment primary key,
-> sanasi date,
-> chiqarilgan_sana date,
-> eslatma char(30));
Query OK, 0 rows affected (0.01 sec)

mysql> alter table xisob_kitob

-> add column xonalar_id int,
-> add foreign key (xonalar_id) references xonalar(id);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
ysql> alter table xisob_kitob
-> add column mijozlar_id int,
-> add foreign key (mijozlar_id) references mijozlar(id);
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> show tables;

+----------------------+
| Tables_in_mehmonxona |
+----------------------+
| mijozlar |
| xisob_kitob |
| xonalar |
+----------------------+
3 rows in set (0.00 sec)

mysql> desc mijozlar;

+---------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| fam | varchar(40) | YES | | NULL | |
| ism | varchar(40) | YES | | NULL | |
| pasport | varchar(40) | YES | | NULL | |
| izoh | text | YES | | NULL | |
+---------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)
RROR 1146 (42S02): Table 'mehmonxona.xisob_kitoblar' doesn't exist
mysql> desc xisob_kitob;
+------------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+----------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| sanasi | date | YES | | NULL | |
| chiqarilgan_sana | date | YES | | NULL | |
| eslatma | char(30) | YES | | NULL | |
| xonalar_id | int(11) | YES | MUL | NULL | |
| mijozlar_id | int(11) | YES | MUL | NULL | |
+------------------+----------+------+-----+---------+----------------+
6 rows in set (0.02 sec)
mysql> desc xonalar;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| soni | int(11) | YES | | NULL | |
| odamlar_soni | int(11) | YES | | NULL | |
| qulaylik | varchar(30) | YES | | NULL | |
| narxi | int(11) | YES | | NULL | |
+--------------+-------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

mysql> INSERT INTO mijozlar (fam, ism, pasport, izoh) VALUES ('Smith', 'John', 'AB1234567', 'Regular customer');

Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO xisob_kitob (sanasi, chiqarilgan_sana, eslatma, xonalar_id, mijozlar_id)
-> VALUES ('2023-07-15', '2023-07-20', 'Payment received', 1, 1);
Query OK, 1 row affected (0.00 sec)

mysql> select*from mijozlar;

+----+-------+------+-----------+------------------+
| id | fam | ism | pasport | izoh |
+----+-------+------+-----------+------------------+
| 1 | Smith | John | AB1234567 | Regular customer |
+----+-------+------+-----------+------------------+
1 row in set (0.00 sec)

mysql> select*from mijozlar;

+----+-------+------+-----------+------------------+
| id | fam | ism | pasport | izoh |
+----+-------+------+-----------+------------------+
| 1 | Smith | John | AB1234567 | Regular customer |
+----+-------+------+-----------+------------------+
1 row in set (0.00 sec)

mysql> select * from xonalar;

+----+------+--------------+----------+-------+
| id | soni | odamlar_soni | qulaylik | narxi |
+----+------+--------------+----------+-------+
| 1 | 10 | 2 | Standard | 100 |
+----+------+--------------+----------+-------+
1 row in set (0.00 sec)

mysql> select*from xisob_kitob;

+----+------------+------------------+------------------+------------+-------------+
| id | sanasi | chiqarilgan_sana | eslatma | xonalar_id | mijozlar_id |
+----+------------+------------------+------------------+------------+-------------+
| 4 | 2023-07-15 | 2023-07-20 | Payment received | 1 | 1 |
+----+------------+------------------+------------------+------------+-------------+
1 row in set (0.00 sec)

mysql>

Xulosa :
Men ushbu amaliy mashg’ulot tayorlash davomida My Sql dasturida Mexmonxonadagi mijozlar, xonalar, hisob-kitoblari jamlab turuvchi malumotar bazasini tayorlashni va ularni bir biriga ulashni o’rgandim.