1 амалий машѓулот

Mavjud bo’lgan Suhbat nomli bazada bir nechta jadval yaratamiz va ularni tegishlicha loyihalaymiz.



1-Rasm.

2-Rasm.

3-Rasm.

4-Rasm.
Bu jadvallarni kerakli so’rovlar orqali loyihalaymiz.
Select concat(`poyezd`,' ', `turi`) as harakatlar,qayerdan,qayerga, summa,sana
from chipta as ch
join harakat as h on ch.id=h.chiptaid
Natija quyidagicha bo’ladi:

5-Rasm.
Bu rasmda biz “Kompaniyalar” va “Operatorlar” nomli jadval maydonlarini birlashtirdik. Endi bu jarayonni bir nechta jadval misolida ko’rib o’tamiz. Buning uchun quyidagi so’rovni beramiz:


Select concat(`poyezd`,' ', `turi`) as harakatlar,qayerdan,qayerga as summa,sana,
concat(`nomi` ,' ', `reys`)as harakatda,p.yulovchiSoni,v.qanaqa,v.nomeri


from chipta as ch
join harakat as h on ch.id=h.chiptaid
left join poyezdlar as p on h.id=p.harakatid
join vagon as v on v.id=p.harakatid

Natija quyidagicha bo’ladi:

6-Rasm.
GROUP BY operatori yordamida loyihalashtirilgan jadvallarni guruxlaymiz.Buning uchun quyidagi so’rovni beramiz:
Select concat(`poyezd`,' ', `turi`) as harakatlar,qayerdan,qayerga as summa,sana,
concat(`nomi` ,' ', `reys`)as harakatda,p.yulovchiSoni,v.qanaqa,v.nomeri


from chipta as ch
join harakat as h on ch.id=h.chiptaid
left join poyezdlar as p on h.id=p.harakatid
join vagon as v on v.id=p.harakatid
Group BY chiptaid
Bunda Operatorlarning idsi guruhlanadi va qaysi operator qaysi mijozga xizmat qilishi aniqlanadi va natija quyidagicha bo’ladi:

7-Rasm.

5-Tajriba ishi