CREATE TABLE Airport
(AirportName CHAR (20), Code CHAR (2) PRIMARY KEY, CountryName CHAR (10), Terminals INT);

CREATE TABLE Country
(CountryName CHAR (10) PRIMARY KEY, Currency CHAR (15), TimeZone INT);

INSERT INTO Airport VALUES('Manchester', 'MAN', 'UK', 3);
INSERT INTO Airport VALUES('Heathrow', 'LHR', 'UK', 5);
INSERT INTO Airport VALUES('Frankfurt', 'FRA', 'Germany', 2);
INSERT INTO Airport VALUES('Gatwick', 'LGW', 'UK', 2);
INSERT INTO Airport VALUES('Hamburg', 'HAM', 'Germany', 2);
INSERT INTO Airport VALUES('Fiumicino', 'FCO', 'UK', 4);

INSERT INTO Country VALUES('Germany', 'Euro', 1);
INSERT INTO Country VALUES('Italy', 'Euro', 1);
INSERT INTO Country VALUES('UK', 'Pound Sterling', 0);