insert into manufacturer
values (210,'United Ship Builders','Bath','ME',4,3);
insert into manufacturer
values (211,'General Ship Builders','San Diego','CA',2,9);
insert into manufacturer
values (212,'Master Dynamics','Bridgeport','CT',9,1);
insert into manufacturer
values (213,'Asia West Ship Builders','Hong Kong','',5,5);
insert into manufacturer
values (214,'Pacific Ship Builders','Fairbanks','AK',6,4);
insert into manufacturer
values (215,'Best Industries','Seattle','WA',3,2);
insert into manufacturer
values (216,'Union Corp','Buffalo','NY',8,11);

insert into ship
values('01',1,100000,'25-Jan-1965',212);
insert into ship
values('05',1,120000,'20-Jan-1969',212);
insert into ship
values('06',1,500000,'7-Mar-1969',212);
insert into ship
values('10',3,20000,'15-Mar-1975',210);
insert into ship
values('11',2,50000,'30-Jan-1971',210);
insert into ship
values('16',2,75000,'1-Nov-1975',215);
insert into ship
values('25',3,15000,'2-Nov-1979',213);
insert into ship
values('35',2,55000,'1-Dec-1989',211);
insert into ship
values('37',1,250000,'2-Dec-1990',216);
insert into ship
values('39',1,500000,'3-Dec-1991',211);

insert into captain
values ('001-01',3,'Robert','Sourchie','01-May-1945');
insert into captain
values ('001-23',1,'Cliff','Walker','01-Feb-1972');
insert into captain
values ('001-24',1,'John','Smith','12-Jan-1957');
insert into captain
values ('002-14',2,'Sal','Levine','20-Feb-1956');
insert into captain
values ('002-15',1,'Henry','Moore','15-Jan-1957');
insert into captain
values ('003-01',3,'James','Westmoreland','12-Feb-1972');
insert into captain
values ('003-02',1,'Earl','Gray','17-Mar-1965');
insert into captain
values ('004-01',2,'Otheno','Vollage','16-Nov-1962');
insert into captain
values ('004-02',1,'Marcia','Nesmith','01-May-1957');
insert into captain
values ('011-11',2,'Phillip','Levinchuck','02-Mar-1962');

insert into item
values ('2101','FP','Beans',500);
insert into item
values ('2109','FP','Corn Meal',200);
insert into item
values ('2123','FP','Rice',300);
insert into item
values ('3212','BM','Cement',2000);
insert into item
values ('3223','BM','Concrete Forms',500);
insert into item
values ('3297','BM','Steel Beam',2000);
insert into item
values ('4521','WP','5/8" Plywood - 200 sheets/pallet',800);
insert into item
values ('4532','WP','Beam',100);
insert into item
values ('4533','WP','2X4X8 Pine Boards',250);
insert into item
values ('7821','AUTO','Toyota Camry',2000);
insert into item
values ('7823','AUTO','Mercury Sable',2500);
insert into item
values ('7829','AUTO','Mercedes',2550);

insert into distance
values ('BOSTON','BRAZIL',2500,4);
insert into distance
values ('BOSTON','LONDON',3000,5);
insert into distance
values ('BOSTON','SEATTLE',6000,7);
insert into distance
values ('BOSTON','SINGAPORE',5000,5);
insert into distance
values ('BRAZIL','BOSTON',2600,5);
insert into distance
values ('LONDON','BOSTON',3000,5);
insert into distance
values ('LONDON','SEATTLE',6500,10);
insert into distance
values ('SEATTLE','BOSTON',6000,7);
insert into distance
values ('SEATTLE','LONDON',6500,10);
insert into distance
values ('SINGAPORE','BOSTON',5000,5);

insert into shipment
values ('00-0001','39','002-15','10-Jan-2000','BOSTON','BRAZIL','14-Jan-2000');
insert into shipment
values ('00-0002','37','004-01','15-Jan-2000','BRAZIL','BOSTON','19-Jan-2000');
insert into shipment
values ('00-0003','10','003-01','20-Jan-2000','BOSTON','SEATTLE','31-Jan-2000');
insert into shipment
values ('00-0004','16','001-24','31-Jan-2000','SEATTLE','LONDON',NULL);
insert into shipment
values ('00-0005','05','004-02','01-Feb-2000','BOSTON','SEATTLE',NULL);
insert into shipment
values ('00-0006','06','003-02','09-Feb-2000','LONDON','SEATTLE',NULL);
insert into shipment
values ('89-0001','05','001-01','15-Jan-1989','SEATTLE','LONDON','21-Jan-1989');
insert into shipment
values ('89-0002','01','001-23','15-Jan-1989','BOSTON','LONDON','21-Jan-1989');
insert into shipment
values ('92-0001','11','002-14','18-Jan-1992','BOSTON','LONDON','30-Jan-1992');
insert into shipment
values ('99-0003','39','001-24','13-Mar-1999','BOSTON','LONDON','18-Mar-1999');

insert into shipment_line
values ('00-0001','3223',100);
insert into shipment_line
values ('00-0001','3297',87);
insert into shipment_line
values ('00-0004','3212',100);
insert into shipment_line
values ('00-0004','3223',50);
insert into shipment_line
values ('00-0006','2101',432);
insert into shipment_line
values ('00-0006','2123',34);
insert into shipment_line
values ('89-0002','3212',10);
insert into shipment_line
values ('89-0002','3223',5);
insert into shipment_line
values ('89-0002','3297',42);
insert into shipment_line
values ('92-0001','7821',5);
insert into shipment_line
values ('92-0001','7829',3);
insert into shipment_line
values ('99-0003','4521',100);
insert into shipment_line
values ('99-0003','4533',1000);
