Ma’lumotlar bazasini boshqarish tizimlari shaxarlar mavzu
![Talim muassasalari mohiyati bu mohiyzt shaxardagi universitaetlar kollejlar, litseylar, maktablar
haqida malumot beradi. ....................................................................................................................... 14
Transport mohiyati bu mohiyat orqali shaxar transport tizimi bn tanishishingiz mumkin hususan
airport, vokzal, avto vokzal taksi park. .................................................................................................. 14
Bozor mohiyati bu mohiyatda bozorning ish kuni, manzili, bozor turi haqidagi malumotlar mavjud. . . 15
.............................................................................................................................................................. 15
3.2. SQL tilida jadvallarga ma’lumotlarni datologik modeli .................................................................. 16
3.3. SQL operatorlari yordamida jadvallarni hosil qilish va jadvallarga ma’lumotlar kiritish ................. 23
CREATE TABLE [shaxar] ( ....................................................................................................................... 23
[id_shaxar] int PRIMARY KEY, .............................................................................................................. 23
[maydoni] nvarchar(255), .................................................................................................................... 23
[aholisi] nvarchar(255), ........................................................................................................................ 23
[markazi] nvarchar(255), ..................................................................................................................... 23
[geografik_orni] nvarchar(255), ........................................................................................................... 23
[mexmonhona] nvarchar(255), ............................................................................................................ 23
[sayohat_markazi] nvarchar(255), ....................................................................................................... 23
[ijtimoiy_obyektlar] nvarchar(255), ..................................................................................................... 23
[Talim_muassasalar] nvarchar(255), .................................................................................................... 23
[Transport] nvarchar(255), .................................................................................................................. 23
[kongil_ochar_markazlar] nvarchar(255), ............................................................................................ 23
[bozorlar] nvarchar(255) ...................................................................................................................... 23
) ............................................................................................................................................................ 23
GO ........................................................................................................................................................ 23
CREATE TABLE [sayohat_markazi] ( ...................................................................................................... 24
[id_sayohat_markazi] int PRIMARY KEY, .............................................................................................. 24
[maydoni] nvarchar(255), .................................................................................................................... 24
[nomi] nvarchar(255), .......................................................................................................................... 24
[tashkil_topgan_vaqti] datetime ......................................................................................................... 24
) ............................................................................................................................................................ 24
GO ........................................................................................................................................................ 24
CREATE TABLE [mexmonhona] ( ........................................................................................................... 24
[id_mehmonhona] int PRIMARY KEY, .................................................................................................. 24
[nomi] nvarchar(255), .......................................................................................................................... 24
3](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_3.png?v=1)
![[manzili] nvarchar(255), ....................................................................................................................... 24
[sigimi] nvarchar(255), ......................................................................................................................... 24
[ish_vaqti] datetime ............................................................................................................................ 24
) ............................................................................................................................................................ 24
GO ........................................................................................................................................................ 24
CREATE TABLE [ijtimoiy_obyektlar] ( .................................................................................................... 25
[id_ijtimoiy_obyekt] int PRIMARY KEY, ................................................................................................ 25
[muzey] nvarchar(255), ....................................................................................................................... 25
[sihatgoh] nvarchar(255), .................................................................................................................... 25
[banklar] nvarchar(255), ...................................................................................................................... 25
[seervis] nvarchar(255) ........................................................................................................................ 25
) ............................................................................................................................................................ 25
GO ........................................................................................................................................................ 25
CREATE TABLE [Transport] ( .................................................................................................................. 25
[id_transport] int PRIMARY KEY, .......................................................................................................... 25
[airport] nvarchar(255), ....................................................................................................................... 25
[vokzal] nvarchar(255), ........................................................................................................................ 25
[avto_vokzal] nvarchar(255), ............................................................................................................... 25
[taksi_park] nvarchar(255) .................................................................................................................. 25
) ............................................................................................................................................................ 25
GO ........................................................................................................................................................ 25
CREATE TABLE [Talim_muassasalar] ( ................................................................................................... 26
[id_talim_muassasa] int PRIMARY KEY, ............................................................................................... 26
[otm] nvarchar(255), ........................................................................................................................... 26
[litsey] nvarchar(255), .......................................................................................................................... 26
[kollej] nvarchar(255), ......................................................................................................................... 26
[maktab] nvarchar(255) ....................................................................................................................... 26
) ............................................................................................................................................................ 26
GO ........................................................................................................................................................ 26
CREATE TABLE [bozorlar] ( .................................................................................................................... 26
[id_bozor] int PRIMARY KEY, ................................................................................................................ 26
[nomi] nvarchar(255), .......................................................................................................................... 26
4](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_4.png?v=1)
![[manzili] nvarchar(255), ....................................................................................................................... 26
[ish_grafigi] nvarchar(255) ................................................................................................................... 26
) ............................................................................................................................................................ 26
GO ........................................................................................................................................................ 26
CREATE TABLE [kongil_ochar_markazlar] ( ........................................................................................... 27
[id_markazlar] int PRIMARY KEY, ......................................................................................................... 27
[nomi] nvarchar(255), .......................................................................................................................... 27
[manzili] nvarchar(255), ....................................................................................................................... 27
[ish_vaqti] nvarchar(255) ..................................................................................................................... 27
) ............................................................................................................................................................ 27
GO ........................................................................................................................................................ 27
ALTER TABLE [mexmonhona] ADD FOREIGN KEY ([id_mehmonhona]) REFERENCES [sayohat_markazi]
([id_sayohat_markazi]) ......................................................................................................................... 27
GO ........................................................................................................................................................ 27
ALTER TABLE [shaxar] ADD FOREIGN KEY ([mexmonhona]) REFERENCES [mexmonhona]
([id_mehmonhona]) ............................................................................................................................. 27
GO ........................................................................................................................................................ 27
ALTER TABLE [Transport] ADD FOREIGN KEY ([id_transport]) REFERENCES [shaxar] ([Transport]) ...... 28
GO ........................................................................................................................................................ 28
ALTER TABLE [Talim_muassasalar] ADD FOREIGN KEY ([id_talim_muassasa]) REFERENCES [shaxar]
([Talim_muassasalar]) .......................................................................................................................... 28
GO ........................................................................................................................................................ 28
ALTER TABLE [ijtimoiy_obyektlar] ADD FOREIGN KEY ([id_ijtimoiy_obyekt]) REFERENCES [shaxar]
([ijtimoiy_obyektlar]) ............................................................................................................................ 28
GO ........................................................................................................................................................ 28
ALTER TABLE [kongil_ochar_markazlar] ADD FOREIGN KEY ([id_markazlar]) REFERENCES [shaxar]
([kongil_ochar_markazlar]) .................................................................................................................. 28
GO ........................................................................................................................................................ 28
ALTER TABLE [bozorlar] ADD FOREIGN KEY ([id_bozor]) REFERENCES [shaxar] ([bozorlar]) ................. 28
GO ........................................................................................................................................................ 28
ALTER TABLE [sayohat_markazi] ADD FOREIGN KEY ([id_sayohat_markazi]) REFERENCES [shaxar]
([sayohat_markazi]) .............................................................................................................................. 29
GO ........................................................................................................................................................ 29
Xulosa ........................................................................................................................................................ 29
Foydalanilgan adabiyotlar .......................................................................................................................... 30
5](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_5.png?v=1)
![3.3. SQL operatorlari yordamida jadvallarni hosil qilish va
jadvallarga ma’lumotlar kiritish
CREATE TABLE [shaxar] (
[id_shaxar] int PRIMARY KEY,
[maydoni] nvarchar(255),
[aholisi] nvarchar(255),
[markazi] nvarchar(255),
[geografik_orni] nvarchar(255),
[mexmonhona] nvarchar(255),
[sayohat_markazi] nvarchar(255),
[ijtimoiy_obyektlar] nvarchar(255),
[Talim_muassasalar] nvarchar(255),
[Transport] nvarchar(255),
[kongil_ochar_markazlar] nvarchar(255),
[bozorlar] nvarchar(255)
)
GO
23](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_23.png?v=1)
![CREATE TABLE [sayohat_markazi] (
[id_sayohat_markazi] int PRIMARY KEY,
[maydoni] nvarchar(255),
[nomi] nvarchar(255),
[tashkil_topgan_vaqti] datetime
)
GO
CREATE TABLE [mexmonhona] (
[id_mehmonhona] int PRIMARY KEY,
[nomi] nvarchar(255),
[manzili] nvarchar(255),
[sigimi] nvarchar(255),
[ish_vaqti] datetime
)
GO
24](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_24.png?v=1)
![CREATE TABLE [ijtimoiy_obyektlar] (
[id_ijtimoiy_obyekt] int PRIMARY KEY,
[muzey] nvarchar(255),
[sihatgoh] nvarchar(255),
[banklar] nvarchar(255),
[seervis] nvarchar(255)
)
GO
CREATE TABLE [Transport] (
[id_transport] int PRIMARY KEY,
[airport] nvarchar(255),
[vokzal] nvarchar(255),
[avto_vokzal] nvarchar(255),
[taksi_park] nvarchar(255)
)
GO
25](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_25.png?v=1)
![CREATE TABLE [Talim_muassasalar] (
[id_talim_muassasa] int PRIMARY KEY,
[otm] nvarchar(255),
[litsey] nvarchar(255),
[kollej] nvarchar(255),
[maktab] nvarchar(255)
)
GO
CREATE TABLE [bozorlar] (
[id_bozor] int PRIMARY KEY,
[nomi] nvarchar(255),
[manzili] nvarchar(255),
[ish_grafigi] nvarchar(255)
)
GO
26](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_26.png?v=1)
![CREATE TABLE [kongil_ochar_markazlar] (
[id_markazlar] int PRIMARY KEY,
[nomi] nvarchar(255),
[manzili] nvarchar(255),
[ish_vaqti] nvarchar(255)
)
GO
ALTER TABLE [mexmonhona] ADD FOREIGN KEY
([id_mehmonhona]) REFERENCES [sayohat_markazi]
([id_sayohat_markazi])
GO
ALTER TABLE [shaxar] ADD FOREIGN KEY ([mexmonhona])
REFERENCES [mexmonhona] ([id_mehmonhona])
GO
27](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_27.png?v=1)
![ALTER TABLE [Transport] ADD FOREIGN KEY ([id_transport])
REFERENCES [shaxar] ([Transport])
GO
ALTER TABLE [Talim_muassasalar] ADD FOREIGN KEY
([id_talim_muassasa]) REFERENCES [shaxar] ([Talim_muassasalar])
GO
ALTER TABLE [ijtimoiy_obyektlar] ADD FOREIGN KEY
([id_ijtimoiy_obyekt]) REFERENCES [shaxar] ([ijtimoiy_obyektlar])
GO
ALTER TABLE [kongil_ochar_markazlar] ADD FOREIGN KEY
([id_markazlar]) REFERENCES [shaxar] ([kongil_ochar_markazlar])
GO
ALTER TABLE [bozorlar] ADD FOREIGN KEY ([id_bozor])
REFERENCES [shaxar] ([bozorlar])
GO
28](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_28.png?v=1)
![ALTER TABLE [sayohat_markazi] ADD FOREIGN KEY
([id_sayohat_markazi]) REFERENCES [shaxar] ([sayohat_markazi])
GO
Xulosa
Hozirgi kunda Respublikamizda keng tarqalib borayotgan ish joylarini
avtomalashtirish va ish joylarida axborot kommunikatsiya vositalaridan keng
foydalanishga katta e’tibor berilmoqda.
Bu Loyihani bajarishda men infologik model, datologik model, relatsion model,
jadvallar yaratish, jadvallarni bir biriga bog’lash, undagi mohiyatlarni tahlil qilish
MySQL da yangi jadvallar yaratish ularni bir birlariga bog’lashni o’rganib
chiqdim.
Shuningdek ma’lumotlar bazasi bilan ishlash, ularni oddiy va dinamik
usullarda tashkil qilish malakasini hosil qildim. Ma’lumotlar bazasini boshqarish
tizimlari bilan tanishib chiqdim va “shaxar” ma’lumotlar bazasini bilan shuningdek
undagi turli xil so’rovlar orqali ishlar olib bordim. SQL surovlari bilan ishlashni
urganib chiqdim CREATE INSERT INTO Shunday surovlar jadval yaratishlarni
bilan tanishib ularni bajarib chiqdim.
Xulosa qilib shuni ta’kidlash mumkin, hozirgi fan-texnika xamda
informatsion texnologiyalarining yordamida Universitet manaviyat bo’limi
ishlarini yanada qulay va oson qilish mumkin.
SHaxarda qilinaydigan manaviyat ishlarini olib boorish yangiliklarni elon
qilish maqolalarni kurish xullas shunga uxshash ishini takomillashtirish va ish
unumdorligini yuqori darajada oshirishga erishishimiz mumkin ekan.
29](https://docx.uz/documents/0fbe484c-d8c7-4589-a831-e8fa76162b13/page_29.png?v=1)
Ma’lumotlar bazasini boshqarish tizimlari shaxarlar mavzu