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

STATIONS jadvali:
CREATE TABLE "STATIONS"
("ID_STATION" NUMBER(*,0) NOT NULL ENABLE,
"NAME_STATION" VARCHAR2(25) NOT NULL ENABLE,
"REGION" VARCHAR2(25) NOT NULL ENABLE,
"ROAD" VARCHAR2(25) NOT NULL ENABLE,
"KEY_ECP" NUMBER(6,0) NOT NULL ENABLE,
PRIMARY KEY ("ID_STATION") ENABLE,
CONSTRAINT "STATION_AK" UNIQUE ("NAME_STATION", "KEY_ECP") ENABLE
)
GROUP_OF_WAGON jadvali:
CREATE TABLE GROUP_OF_WAGON
(ID_GROUP_OF_WAGON NUMBER(*,0),
ID_WAGON NUMBER(*,0) NOT NULL ENABLE,
ID_TRAIN NUMBER(*,0),
PRIMARY KEY (ID_GROUP_OF_WAGON) ENABLE,
CONSTRAINT ID_WAGON_FK FOREIGN KEY (ID_WAGON)
REFERENCES WAGON (ID_WAGON) ENABLE,
CONSTRAINT ID_TRAIN_FK FOREIGN KEY (ID_TRAIN)
REFERENCES TRAIN (ID_TRAIN) ENABLE
)


TRAIN jadvali:
CREATE TABLE TRAVEL
(ID_TRAVEL NUMBER(*,0),
ID_START_STATION NUMBER(*,0) NOT NULL ENABLE,
ID_FINISH_STATION NUMBER(*,0) NOT NULL ENABLE,
ID_TRAIN NUMBER(*,0) NOT NULL ENABLE,
DISTANCE NUMBER(4,1) NOT NULL ENABLE,
DATE_OF_DEPARTURE DATE NOT NULL ENABLE,
DATE_OF_ARRIVAL DATE NOT NULL ENABLE,
PRIMARY KEY (ID_TRAVEL) ENABLE,
CONSTRAINT START_STATION_FK FOREIGN KEY (ID_START_STATION)
REFERENCES STATIONS (ID_STATION) ENABLE,
CONSTRAINT FINISH_STATION_FK FOREIGN KEY (ID_FINISH_STATION)
REFERENCES STATIONS (ID_STATION) ENABLE,
CONSTRAINT TRAIN_FK FOREIGN KEY (ID_TRAIN)
REFERENCES TRAIN (ID_TRAIN) ENABLE
)

Jadvallarimizni ham yaratib oldik.

Shakllangan bazaga ma’lumot qo’shish

INSERT INTO LOCOMOTIVE

VALUES(1,25146856,’cargo’,1,’DC’,’NEVZ’,1986,1)
INSERT INTO LOCOMOTIVE
VALUES(2,25146857,’cargo’,1,’DC’,’NEVZ’,1986,2)
INSERT INTO LOCOMOTIVE
VALUES(1,25146868,’cargo’,1,’DC’,’Votkinskii zavod’,1987,1)

INSERT INTO STATIONS
VALUES(3,’Omsk-east’,’Omskaya obl.’,’Zapodno-Sibirskaya’,831203)
INSERT INTO STATIONS
VALUES(2,’Abakan,’resp.Khakassia’,’KrasnoYarskaya,888004)
INSERT INTO STATIONS
VALUES(1,’Krasnoyarsk’,’KrasnoYarskii kr.’,Krasnoyarskaya’,890004)


INSERT INTO WAGON
VALUES(1,241597,’К’,26 ,’Votkinskii zavod’,1980,1)
……
Va shu kabi boshqa yozuvlarni ham qo`shib chiqamiz.

Qolgan jadvallarga ham huddi shu kabi ma`lumotlarni qo`shib chiqamiz.