Aviafirma

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,
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 company(name) VALUES (“AeroDenis”);
INSERT INTO company(name) VALUES (“AeroBoengProduction”);
INSERT INTO company(name) VALUES (“AeroCucumber”);
INSERT INTO company(name) VALUES (“AeroBoom”);
INSERT INTO company(name) VALUES (“AeroApple”);

INSERT INTO trip(plane,town_from,town_to,time_out,time_in)
VALUES(“Bibi”,”Moskva”,”Tallinn”,”2023-09-24″,”2023-09-25″);
INSERT INTO trip(plane,town_from,town_to,time_out,time_in)
VALUES(“Mercedes B5″,”Baku”,”Tokio”,”2023-12-24″,”2024-01-9″);
INSERT INTO trip(plane,town_from,town_to,time_out,time_in)
VALUES(“Audi C17″,”Joshkar-Ola”,”Valga”,”2023-05-12″,”2024-05-15″);
INSERT INTO trip(plane,town_from,town_to,time_out,time_in)
VALUES(“BMW OAO”,”Tokio”,”Jõhvi”,”2023-01-25″,”2024-01-27″);
INSERT INTO trip(plane,town_from,town_to,time_out,time_in)
VALUES(“Dota 2″,”Washington”,”Kiev”,”2023-04-15″,”2024-04-17″);

INSERT INTO passenger(name) VALUES(“Deniss Gorjunov”);
INSERT INTO passenger(name) VALUES(“Aleksonder Ragavski”);
INSERT INTO passenger(name) VALUES(“Temar Dunisenko”);
INSERT INTO passenger(name) VALUES(“Jakor Kukushka”);
INSERT INTO passenger(name) VALUES(“Lula Kuma”);

не сохранил код.. пример как делал:

INSERT INTO pass_in_trip(trip_no,date_,ID_psg,place) VALUES(1,”2023-12-25″,1,”61A”)

вся таблица