create table ucak (
ucak_id varchar2(5) not null constraint pk_ucak primary key,
ucak_tipi varchar(20),
kapasite int,
uretim_tarihi int
)
Table created.
create table rota (
rota_id varchar2(5) constraint pk_rota primary key not null,
varis_ha varchar2(5),
kalkis_ha varchar2(5),
kalkis varchar2(10),
varis varchar2(10)
)
Table created.
create table iletisim_detaylari(
ilet_id varchar2(5) primary key constraint pk_ilet not null,
isim varchar2(15),
yas int,
uyruk varchar2(10),
email varchar2(50),
telefon varchar2(15)
)
Table created.
create table yolcu (
yolcu_id varchar2(10) not null,
ilet_id varchar2(5) not null,
constraint pk_yolcu primary key (yolcu_id),
constraint fk_ilet foreign key (ilet_id) references iletisim_detaylari(ilet_id)
)
Table created.
create Table ucus_tarifesi (
ucus_id varchar2(5) not null constraint pk_ucus primary key,
ucak_id varchar2(5) not null,
rota_id varchar2(5) not null,
ucus_tarihi timestamp,
constraint fk_ucak foreign key (ucak_id) references ucak(ucak_id),
constraint fk_rota foreign key (rota_id) references rota(rota_id)
)
Table created.
create table islem (
islem_id varchar2(5) constraint pk_islem primary key not null,
ucus_id varchar2(5) not null,
yolcu_id varchar2(5) not null,
booking_date timestamp,
constraint fk_ucus foreign key (ucus_id) references ucus_tarifesi(ucus_id),
constraint fk_yolcu foreign key (yolcu_id) references yolcu(yolcu_id)
)
Table created.