Nazorat savollari - Hozirgi kunda inson faoliyatida ma’lumotlar bazasi (MB) kerakli

Nazorat savollari
1. Ketma-ketliklar nima? Uni qanday yaratasiz?
2. Ketma-ketliklar yaratish buyrug‘ining parametrlari?
3. Paket nimani o‘z ichiga olishi mumkin?
4. Paket qanday qismlardan iborat?
5. Trigger nima?
6. Trigger qanday yaratiladi?
7. Triggerlarning qanday turlari mavjud?
13-LABORATORIYA ISHI
Application Builder utilitasi yordamida ilovalar yaratish
Ishdan maqsad: Application Builder utilitasi yordamida ilovalar
yaratishni o‘rganish.
Topshiriqlar:
1. “O‘qituvchilar”, “Talabalar”, “O‘zlashtirish” va “Jadvalni tahrirlash”
bo‘limlaridan iborat ilova yarating.
“O‘qituvchilar” bo‘limi – har bir o‘qituvchi qaysi guruhlarda qaysi
fanlardan dars berishi haqida ma’lumot bersin.
“O‘zlashtirish” bo‘limi – tanlangan guruh va fan bo‘yicha talabalar
baholari haqida ma’lumot bersin.
2. “Application Builder utilitasi yordamida ilovalar yaratish” hisobotini
tayyorlang.
3. Nazorat savollariga javob berib, laboratoriya ishini himoya qiling.
Nazariy ma’lumotlar
Oracle XE da ilova yaratish uchun Home –> Application Builder–
>Create buyrug‘ini bajaring (13.1 – rasm).
13.1-rasm. Ilova yaratish oynasi
Keyin, ilovani yaratish usulini tanlang (13.2-rasm).
13.2-rasm. Ilova yaratish usulining tanlash oynasi
1. Name maydoniga (13.3-rasm) ilova nomini kiriting.
2. Application maydoniga ilova uchun unikal qiymat kiriting.
3. Create Application maydonida ilovani yangi ilova yaratish yoki
shablon asosida yaratish usulini tanlang;
4. “Schema” bo‘limida HANDSONXE06 ni tanlang.
5. “Next” tugmasini bosing.
13.3-rasm. Name oynasi
Pages oynasida (13.4-rasm) mavjud jadvallarni ilovaga qo‘shish
imkonini beradi.
13.4-rasm. Pages sahifasi
Agar jadvallar va formalardan hisobotlar yaratish uchun Add Page
oynasidan hisobot(Report) va Forma(Form) tugmalarini bosing hamda
ilovaning bosqichlarini (level) ko‘rsating.
Table Name maydonida ro‘yxatdan jadvalni tanlang (рис. 11 и 12).
13.5-rasm. Hisobot va formani yaratuvchi oyna
13.6-rasm. Jadvalni tanlash oynasi
3. Add Page tugmasini bosing.
13.7-rasm. Sahifalar qo‘shish
5. Ilovaga yangi jadval va formalarni qo‘shish uchun yuqoridagi
amallarni bajaring. Next tugmasini bosing (13.8-rasm).
13.8-rasm. Ilova sahifasi
Tabs sahifasida ilovaning ishlash prinsipi ko‘rsatiladi. Masalan, bitta
bo‘limli ko‘rinish (One Level of Tabs) ni tanlang. Next tugmasini bosing.
(13.9-rasm)
13.9-rasm. Tabs sahifasi
Shared Components sahifasida (13.10-rasm) yaratilayotdan ilovada
Oracle Application Express ning boshqa ilovalaridagi komponentlarini
nusxalash yo‘li bilan mutanosib ishlatilishi haqida so‘raladi. Agarda bu ilova
sizning birinchi ilovangiz bo‘lsa, u holda yo‘q (No) ni tanlang. Next
tugmasini bosing.
13.10-rasm. Shared Components oynasi
Attributes sahifasida (13.11-rasm) ilovaning bir qancha xossalarini
o‘rnatish mumkin:
Authentication Scheme – yangi ilovaning xavfsizligi qanday tarzda
ta’minlanishini ko‘rsatadi.
Language – ilova yaratishda qaysi tildan foydalanish ko‘rsatiladi.
User Language Preference Derived From – ilovani qanday qilib qaysi
tildan foydalanishini ko‘rsatadi.
Next tugmasini bosing.
13.11-rasm. Attributes oynasi
User Interface sahifasidan ilova uchun shablon tanlang.
13.12–rasm. User Interface sahifasi
Ilovani yaratish uchun Create tugmasini bosing (13.13-rasm).
13.13-rasm. Yangi ilovani yaratish oynasi
13.14-rasm. Ilova kompilyatsiyasi sahifasi
|