create_tables.sql ; DROP TABLE Flight; DROP TABLE AirPlane; DROP TABLE Pilot; CREATE TABLE AirPlane( NumAP INTEGER NOT NULL PRIMARY KEY, NameAP char(10) NOT NULL, Capacity INTEGER NOT NULL, Localisation CHAR(30) NOT NULL ); CREATE TABLE Pilot( NumP INTEGER NOT NULL PRIMARY KEY, NameP CHAR(10) NOT NULL, Address CHAR(30) NOT NULL, Salary INTEGER NOT NULL ); CREATE TABLE Flight( NumF INTEGER NOT NULL PRIMARY KEY, NumP INTEGER, NumAP INTEGER, DEP_H CHAR(15) NOT NULL, DEP_T CHAR(25) NOT NULL, ARR_H CHAR(15) NOT NULL, ARR_T CHAR(25) NOT NULL, FOREIGN KEY ( NumP ) REFERENCES Pilot( NumP ), FOREIGN KEY ( NumAP ) REFERENCES AirPlane( NumAP ) ); INSERT INTO Pilot VALUES( 2, 'Peter', 'Nice', 325000 ); INSERT INTO Pilot VALUES( 3, 'Peter', 'Paris', 250000 ); INSERT INTO Pilot VALUES( 4, 'Scott', 'Marseille', 250000 ); INSERT INTO Pilot VALUES( 5, 'Tigger', 'Marseille', 250000 ); INSERT INTO Pilot VALUES( 6, 'Jhon', 'Nice', 300000 ); INSERT INTO Pilot VALUES( 7, 'Bill', 'Marseille', 325000 ); INSERT INTO Pilot VALUES( 8, 'Tigger', 'Paris', 250000 ); INSERT INTO Pilot VALUES( 9, 'Tigger', 'Paris', 300000 ); INSERT INTO AirPlane VALUES( 101, 'A300', 300, 'Marseille' ); INSERT INTO AirPlane VALUES( 102, 'A330', 300, 'Nice' ); INSERT INTO AirPlane VALUES( 103, 'A300', 300, 'Paris' ); INSERT INTO AirPlane VALUES( 104, 'A330', 300, 'Marseille' ); INSERT INTO AirPlane VALUES( 105, 'A330', 300, 'Marseille' ); INSERT INTO AirPlane VALUES( 106, 'A320', 300, 'Nice' ); INSERT INTO AirPlane VALUES( 107, 'A320', 300, 'Marseille' ); INSERT INTO AirPlane VALUES( 108, 'A330', 300, 'Paris' ); INSERT INTO AirPlane VALUES( 109, 'A350', 500, 'Paris' ); INSERT INTO Flight VALUES( 1002, 3, 104, '2:00 PM', 'Marseille', '2:20 PM', 'Nice' ); INSERT INTO Flight VALUES( 1003, 4, 105, '1:00 AM', 'Paris', '2:05 AM', 'Nice' ); INSERT INTO Flight VALUES( 1004, 2, 101, '12:00 AM', 'Paris', '1:00 PM', 'Marseille' ); INSERT INTO Flight VALUES( 1005, 3, 101, '12:00 AM', 'Marseille', '12:45 PM', 'Lyon' ); INSERT INTO Flight VALUES( 1006, 4, 107, '9:00 AM', 'Nice', '9:20 AM', 'Marseille' ); INSERT INTO Flight VALUES( 1007, 5, 101, '10:00 AM', 'Paris', '10:45 AM', 'Lyon' ); INSERT INTO Flight VALUES( 1008, 6, 101, '7:00 PM', 'Lyon', '7:45 PM', 'Marseille' ); INSERT INTO Flight VALUES( 1009, 7, 101, '4:00 PM', 'Paris', '5:00 PM', 'Marseille' ); INSERT INTO Flight VALUES( 1010, 2, 109, '8:00 AM', 'Nice', '9:00 AM', 'Paris' );