rockcairn logoRockCairn.com rockcairn logo
PROMPT
insert into Airports values ('LAX',800);
insert into Airports values ('DEN',900);
insert into Airports values ('JFK',1000);
COMMIT;

PROMPT
insert into Plane_models values ('DC10',250);
insert into Plane_models values ('B747',300);
COMMIT;

PROMPT
insert into Mileages values ('LAX','DEN',990);
insert into Mileages values ('DEN','JFK',1900);
insert into Mileages values ('LAX','JFK',2700);
COMMIT;

PROMPT
insert into Planes values ('N3210X','DC10','DEN','United');
insert into Planes values ('N1111E','DC10','DEN','United');
insert into Planes values ('N1000N','DC10','LAX','United');
insert into Planes values ('N110DE','DC10','LAX','United');
insert into Planes values ('N9021C','B747','LAX','Continental');
insert into Planes values ('N1321X','B747','LAX','American');
insert into Planes values ('N2333W','DC10','JFK','American');
insert into Planes values ('N1921B','DC10','JFK','American');
insert into Planes values ('N6666L','B747','JFK','Continental');
COMMIT;

PROMPT
insert into Flights values ('United',347,250,'LAX','JFK','8:22','16:49');
insert into Flights values ('United',563,250,'DEN','JFK','9:40','15:00');
insert into Flights values ('United',863,250,'DEN','LAX','11:30','13:00');
insert into Flights values ('Continental',322,300,'LAX','JFK','8:05','14:38');
insert into Flights values ('Continental',822,300,'JFK','LAX','8:05','8:59');
insert into Flights values ('American',101,250,'JFK','LAX','9:05','12:39');
COMMIT;

PROMPT
insert into Departures values ('1/12/97','United',347,1,200,'N110DE');
insert into Departures values ('1/12/97','United',347,2,101,'N110DE');
insert into Departures values ('1/12/97','Continental',322,1,300,'N9021C');
insert into Departures values ('1/13/97','United',347,1,190,'N1000N');
insert into Departures values ('1/13/97','United',347,2,110,'N1000N');
insert into Departures values ('1/14/97','American',101,1,210,'N1321X');
insert into Departures values ('1/14/97','American',101,2,208,'N1321X');
insert into Departures values ('1/15/97','Continental',822,1,208,'N6666L');
COMMIT;

PROMPT
insert into Flight_Segments values ('United',347,1,'DC10','8:22','11:58','LAX','DEN',489.00);
insert into Flight_Segments values ('United',347,2,'DC10','12:35','16:49','DEN','JFK',325.00);
insert into Flight_Segments values ('Continental',322,1,'B747','8:05','14:38','LAX','JFK',625.00);
insert into Flight_Segments values ('Continental',822,1,'B747','8:05','8:59','JFK','LAX',650.00);
insert into Flight_Segments values ('American',101,1,'B747','9:05','10:00','JFK','DEN',333.00);
insert into Flight_Segments values ('American',101,2,'DC10','11:05','12:39','DEN','JFK',360.00);
insert into Flight_Segments values ('United',563,1,'DC10','9:40','15:00','DEN','JFK',380.00);
insert into Flight_Segments values ('United',863,1,'DC10','11:30','13:00','DEN','LAX',450.00);
COMMIT;