USE database1;
CREATE TABLE Flights(
[flno]        smallint              NOT NULL ,
[from]        VarChar(30)           NOT NULL ,
[to]          VarChar(30)           NOT NULL ,
[distance]    smallint              NOT NULL ,
[departs]     time                  NOT NULL 
);

CREATE TABLE Aircraft (
aid           smallint              NOT NULL,
aname         VarChar(30)           NOT NULL,
cruisingrange smallint              NOT NULL
);
CREATE TABLE Employee (
eid           smallint              NOT NULL,
ename         VarChar(30)           NOT NULL,
salary        int                   NOT NULL
);
CREATE TABLE Certified (
eid           smallint              NOT NULL,
aid           smallint              NOT NULL
);