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 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(‘Nordica’);
INSERT INTO company(name) VALUES(‘Ryanair’);
INSERT INTO company(name) VALUES(‘Airbaltic’);
INSERT INTO company(name) VALUES(‘Aviaseils’);
INSERT INTO company(name) VALUES(‘Pegasus’);

Company

Passenger

Trip