Topshiriq lab dan lab gacha ishlar

Topshiriq 1

1. 
   Lab 1 dan lab 4 gacha ishlar.
   

1. 
   Ma’lumotlar bazasini loyihalash, mohiyat – aloqa diagrammasini qurish.
   
2. 
   Rеlyatsion ma’lumotlar bazasini loyihalash.
   
3. 
   SQL tilida jadvallar yaratish, o‘zgartirish va o‘chirish.
   
4. 
   Ma’lumotlarni tanlash va ular ustida amallar.
   

max bal 5 bal

Baxolash kiteriylari max bal 5 bal(xar bir mavzu uchun aloxida xisoblanadi)

1. 
   Mavzuni nazariy yoritilishi va bajarilganligi – 0.5(*4) bal
   
2. 
   Ishning natijasi – 0.5 (*4) bal
   
3. 
   Ishning ximoyasi 0.25(*4) bal
   

Topshiriq 2

2. 
   Lab 5 dan lab 8 gacha ishlar.
   

5. 
   AND, OR, NOR mantiqiy stanndart so‘zlardan foydalanish.
   
6. 
   Ma’lumotlarni saralash. Where standart so‘zidan foydalanish.
   
7. 
   Group by va Order by standart so‘zlaridan foydalanib so‘rov yaratish.
   
8. 
   Having standart so‘zi orqali so‘rovlar yaratish.
   

max bal 5 bal

Baxolash kiteriylari

1. 
   Mavzuni nazariy yoritilishi va bajarilganligi – 0.5(*4) bal
   
2. 
   Ishning natijasi – 0.5(*4) bal
   
3. 
   Ishning ximoyasi 0.25(*4) bal
   

Topshiriq 3-4-5

3. 
   Lab 9 dan lab 20 gacha ishlar.
   

Uslubiy ko’rsatma bo’yicha

max bal 15 bal

Baxolash kiteriylari

1. 
   Mavzuni nazariy yoritilishi va bajarilganligi – 0.5(*12) bal
   
2. 
   Ishning natijasi – 0.5(*12) bal
   

4. 
   Ishning ximoyasi 0.25(*12) bal