create table ucak ( 
    ucak_id varchar2(5) not null constraint pk_ucak primary key, 
    ucak_tipi varchar(20),  
    kapasite int, 
    uretim_tarihi int 
)

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) 
)

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) 
)

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) 
)

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) 
)

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) 
)