create table Company (
ID_comp int primary key auto_increment,
name char(10)
);

create table  Trip (
trip_no  int primary key auto_increment, 
ID_comp int,
foreign key (ID_comp) references Company(ID_comp), 
plane char(10), 
town_from char(25), 
town_to char(25),
time_out datetime,
time_in datetime
);

create table Passenger (
ID_psg int primary key auto_increment,
name char(20)
);

create table Pass_in_trip (
trip_no  int primary key auto_increment,
foreign key (trip_no) references Trip(trip_no),
date_ datetime,
ID_psg int,
foreign key (ID_psg) references Passenger(ID_psg),
place char(10)
)

INSERT INTO company(name)
VALUES('Air Russia');
INSERT INTO company(name)
VALUES('Air USA');
INSERT INTO company(name)
VALUES('Air China');
INSERT INTO company(name)
VALUES('Air Japan');
INSERT INTO company(name)
VALUES('Air Egypty');

INSERT INTO passenger(name)
VALUES('Diego');
INSERT INTO passenger(name)
VALUES('Mark');
INSERT INTO passenger(name)
VALUES('Michael');
INSERT INTO passenger(name)
VALUES('Martin');
INSERT INTO passenger(name)
VALUES('Alina');

create table Pass_in_trip (
trip_no int,
foreign key (trip_no) references Trip(trip_no),
date_ datetime,
ID_psg int,
foreign key (ID_psg) references Passenger(ID_psg),
place char(10),
primary key (trip_no, date_,ID_psg)
)

INSERT INTO pass_in_trip(trip_no,date_,ID_psg,place)
VALUES(2’2023-10-04′,1,’C-8′);
SELECT * FROM pass_in_trip