SQL ülesanded: AB Aviafirma

cамостоятельно составь запросы на создание таблиц Passenger и Pass_in_trip

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

Заполни данные таблицы 5 записями.

Insert into company(name)
Values ('qantas');
Insert into company(name)
Values ('Nordica');
Insert into company(name)
Values ('Air Kyrgyz');
Insert into company(name)
Values ('Nordwind A');
Insert into company(name)
Values ('Smartavia');
select * from company

Insert into passenger(name)
Values ('Samuel Adamson');
Insert into passenger(name)
Values ('Robert Johnson');
Insert into passenger(name)
Values ('Joseph Evans');
Insert into passenger(name)
Values ('Harry Parson');
Insert into passenger(name)
Values ('Jamal Flatcher');
select * from passenger

Insert into pass_in_trip(trip_no,date_,ID_psg,place)
Values (1,'2023-12-04',1,'C-9');
Insert into pass_in_trip(trip_no,date_,ID_psg,place)
Values (2,'2023-09-09',1,'A-16');
Insert into pass_in_trip(trip_no,date_,ID_psg,place)
Values (3,'2023-04-23',1,'B-14');
Insert into pass_in_trip(trip_no,date_,ID_psg,place)
Values (4,'2023-01-14',1,'B-2');
Insert into pass_in_trip(trip_no,date_,ID_psg,place)
Values (5,'2023-10-29',1,'A-8');
select * from pass_in_trip

Insert into trip(plane,town_from,town_to,time_out,time_in)
Values ('Airbus','Tallinn','Moskva','2022-12-09','2022-12-10');
Insert into trip(plane,town_from,town_to,time_out,time_in)
Values ('Boeing','Kiev','Narva','2022-10-09','2022-09-26');
Insert into trip(plane,town_from,town_to,time_out,time_in)
Values ('Airbus','Frankfurt','Lviv','2022-09-09','2022-08-25');
Insert into trip(plane,town_from,town_to,time_out,time_in)
Values ('Boeing','New York','Lisabon','2022-04-09','2022-07-23');
Insert into trip(plane,town_from,town_to,time_out,time_in)
Values ('Airbus','Tallinn','Kiev','2022-12-26','2022-02-29');
select * from trip