O’zbekiston milliy universiteti amaliy matematika va intellektual texnologiyalar fakulteti axborot tizimlarining matematik va dasturiy ta’minoti yo’nalishi III kurs 19-01 guruh talabasining Ma’lumotlar bazasini boshqarish tizimlari fanidan kurs ishi

Generate bo’limidan.

Ok bilan davom etsak bizga biz tuzgan barcha jadvallarni SQL so’rovlari orqali chizib beradi.



Ma’lumotlar bazasini shakllanishi
Ma’lumotlar bazasni shakllantirish uchun avvalo  Oracleda database yaratib olamiz ushbu yaratish davomida database nomi va username bilan passport kiritamiz va esda saqlaymiz. Bu biz uchun database yaratishni amalga oshirish imkonini beradi, undan so’ng sqldeveloper ni ishga tushirib unga yaratilgan bazani ulaymiz bu bizga qulay ishlash muhitni beradi.Ishga tushgandan so’ng quydagi kodlarni kiritamiz.


……..

Oxridagi save buyrug’ini tanlaymiz.

Qayerga qanday saqlashni so’raydi.

Biz nom berib saqlab qo’yamiz. Va jadvallarni Ma’lumotlar bazasida yaratish uchun SQL developerga kirib hozir saqlagan faylni ichidagi kodlarni ishlatmiz.




Oracle malumotlar bazasidan yangi baza yaratamiz.


Jadvallarni yaratish uchun so`rovlar:
LOCOMOTIVE jadvali:
CREATE TABLE LOCOMOTIVE
(ID_LOCOMOTIVE NUMBER(*,0),
CATEGORY VARCHAR2(15) NOT NULL ENABLE,
NUMBER_OF_SECTIONS NUMBER(1,0) NOT NULL ENABLE,
MOTIVE_POWER VARCHAR2(17) NOT NULL ENABLE,
MANUFACTURER VARCHAR2(10) NOT NULL ENABLE,
YEAR_OF_PRODUCTION DATE,
ID_STATION NUMBER(*,0) NOT NULL ENABLE,
SERIAL_NUMBER NUMBER(8,0) NOT NULL ENABLE,
PRIMARY KEY (ID_LOCOMOTIVE) ENABLE,
CONSTRAINT ID_STATION_FK FOREIGN KEY (ID_STATION)
REFERENCES STATIONS (ID_STATION) ENABLE
)
WAGON jadvali:
CREATE TABLE WAGON
(ID_WAGON NUMBER(*,0),
SERIAL_NUMBER NUMBER(8,0) NOT NULL ENABLE,
MODEL VARCHAR2(15) NOT NULL ENABLE,
TYPE VARCHAR2(15) NOT NULL ENABLE,
NUMBER_OF_SEATS NUMBER(2,0) NOT NULL ENABLE,
MANUFACTURER VARCHAR2(10) NOT NULL ENABLE,
YEAR_OF_PRODUCTION DATE NOT NULL ENABLE,
ID_STATION" NUMBER(*,0) NOT NULL ENABLE,
PRIMARY KEY (ID_WAGON) ENABLE,
CONSTRAINT WAGON_AK UNIQUE (SERIAL_NUMBER, YEAR_OF_PRODUCTION) ENABLE,
CONSTRAINT ID_STATION_FK_WAGON FOREIGN KEY (ID_STATION)
REFERENCES STATIONS (ID_STATION) ENABLE
)
TRAIN jadvali:
CREATE TABLE TRAIN
(ID_LOCOMOTIVE NUMBER(*,0) NOT NULL ENABLE,
ID_TRAIN NUMBER(*,0) NOT NULL ENABLE,
PRIMARY KEY (ID_TRAIN) ENABLE,
CONSTRAINT LOCOMOTIVE_FK FOREIGN KEY (ID_LOCOMOTIVE)
REFERENCES LOCOMOTIVE (ID_LOCOMOTIVE) ENABLE
)