Mavzu: Ma’lumotlar bazasini loyixalash. Ma’lumotlar bazasi dasturlarini o’rnatish va sozlash. Moxiyat aloqa diogrammasini qurish. Relyatsion ma’lumotlar bazasini loyihalash
Download 1.36 Mb.
|
Malumotlar bazasi Sodiqov Diyorbek MB
- Bu sahifa navigatsiya:
- 2-Amaliy mashg’ulot
- Maqsad
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.
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. Download 1.36 Mb. Do'stlaringiz bilan baham: |
Ma'lumotlar bazasi mualliflik huquqi bilan himoyalangan ©fayllar.org 2024
ma'muriyatiga murojaat qiling
ma'muriyatiga murojaat qiling