create table flights
(
flightnumber varchar(20) primary key,
departure varchar(20),
destination varchar (20),
flightdate date,
planemodel varchar(20),
price int,
);

create table hotels
(
hotelsn varchar(20) primary key,
hotelname varchar(20),
country varchar(20),
city varchar (20),
street varchar (20),
housenumber int,
hotelrank int,
price int,
);

create table clients
(
id varchar (20) primary key,
passportid varchar (20),
firstname varchar (20),
lastname varchar (20),
country varchar(20),
city varchar(20),
street varchar(20),
birthday date,
phonenumber varchar(20),
email varchar(20),
);

create table Orders
(
Ordernumber varchar(20) primary key,
dealtype varchar(20),
dealdate date,
nights int,
totalprice int,
people int,
);

create table flightsorders
(
orderid varchar (20) foreign key references Orders (Ordernumber),
flightnumber varchar (20) foreign key references flights ( flightnumber),
);

create table hotelsorders
(
orderid varchar (20) foreign key references Orders (Ordernumber),
hotelsnumber varchar (20) foreign key references hotels ( hotelsn),
);

create table clientsorders
(
id varchar (20) foreign key references clients (id),
hotelsnumber varchar (20) foreign key references hotels ( hotelsn),
);

insert into flights
values      ('A3555','TLV','SKG','2019-05-06','Airbus A320','57 Euro'),
            ('LH789','EWR','TLV','2019-08-07','Boeing 737-MAX','450 Euro'),
            ('UA084','SFO','LHX','2019-08-07','Boeing 767','150 Euro'),
            ('AC084','EWR','THX','2019-08-07','Boeing 737-MAX','450 Euro'),
            ('AL041','HER','MXP','2020-04-07','A380','100 Euro')

insert into hotels
values
            ('35649','Regent Berlin','Germany','Berlin','Charlottenstr','49, Mitte','5','280 Euro'),
            ('52345','Ammon Zeus','Greece','Halkidiki','Kallithea','630 77','5','100 Euro'),
            ('31454',' BoHo Prague Hotel','Czech Republic','Prague','Senovážná','4','4','190 Euro'),
            ('21548','B Hotel','Spain','Barcelona','Gran Vía','389','3','150 Euro'),
            ('95642',' Resort & Spa Hotel NEMO with dolphins','Ukraine','Odesa','Plyazh Lanzheron','25','5','155 Euro')

insert into clients
values
            ('201274891','259878','Oren','Levi','Israel','Tel Aviv','1995-6-2','0544487423'),
            ('311444869','655646','Dror','Shvetz','The boys castle','2012-6-2','0539874234','100 Euro'),
            ('315748963','625643','Avner','Katz','Israel','Afula','1985-6-2','0545434154'),
            ('311444779','147896','Pishoto','Hazak','France','Lyon','1999-6-2','053494546'),
            ('320198463','315454','Daniel','Barak','Israel','Karmiel','1994-2-18','155 Euro')