use database1
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (101, 'New York', 'Chicago', 1500, '08:50:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (104, 'Los Angeles', 'Chicago', 2050, '18:45:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (119, 'Orlando', 'Seatle', 3500, '04:00:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (137, 'Memphis', 'Cincinnati', 500, '14:30:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (178, 'Cleveland', 'Atlanta', 1000, '06:20:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (199, 'Mobile', 'Liverpool', 1800, '10:10:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (180, 'Phoenix', 'Denver', 1300, '03:55:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (114, 'Miami', 'Anchorage', 6000, '19:40:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (166, 'Seatle', 'Key west', 4750, '20:20:00' );
INSERT INTO dbo.Flights (flno, [from], [to], distance, departs)
VALUES (149, 'San Francisco', 'St. Louis', 2000, '21:35:00' );

INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (305, 'Airbus320', 2500 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (309, 'Boeing707', 1000 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (307, 'RJR145', 800 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (310, 'Boeing777', 5000 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (405, 'Airbus420', 1900 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (970, 'Boeing717', 2000 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (188, 'Crazysky100', 3500 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (340, 'Scary210', 2700 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (600, 'Kamikaze400', 1200 );
INSERT INTO dbo.Aircraft (aid, aname, cruisingrange)
VALUES (888, 'Concord100', 8000 );

INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (804, 'James Dean', 100000 );
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (810, 'Scarlet Johansson', 110000 );
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (820, 'Jerry Seinfeld', 70000);
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (830, 'Victor Hugo', 40000);
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (850, 'Johnny Weismuller', 60000);
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (843, 'Stephen Spielberg', 120000 );
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (878, 'Vladimir Putin', 999999 );
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (825, 'Jojo Halastra', 90000);
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (899, 'Leo Messi', 900000 );
INSERT INTO dbo.Employee (eid, ename, salary)
VALUES (860, 'Arnold Schwarzenegger', 30000 );

INSERT INTO dbo.Certified (eid, aid)
VALUES (804, 188 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (804, 405 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (804, 340 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (804, 600 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (810, 970 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (810, 305 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (810, 600 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (810, 188 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (830, 888 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (850, 310 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (850, 309 );
INSERT INTO dbo.Certified (eid, aid)
VALUES (850, 600 );