insert into customer values (101,"Bandy's Hardware","110 Main","","Chicago","IL","60068","Bob Bandy","630-221-9055");
insert into customer values (102,"The FIX-IT Shop","65W Elm Street Sqr.","","Madison","WI","65454","","630-34343434");
insert into customer values (103,"Hill's Hobby Shop","553 Central Parkway","","Eau Claire","WI","54354","Janice Hilstrom","666-4564564");
insert into customer values (104,"Illinois Hardware","123 Main Street","","Peoria","IL","63434","Ramon Aguirra","630-3434334");
insert into customer values (105,"Tools and Stuff","645W Center Street","","Dubuque","IA","54654","Lavonne Robinson","630-4533456");
insert into customer values (106,"TrueTest Hardware","6123 N. Michigan Ave","","Chicago","IL","60104","Michael Mazukelli","640-3453456");
insert into orders values (1,"04/04/2003",103,"ASC","FEDEX","N");
insert into orders values (2,"06/06/2003",103,"ASC","FEDEX","Y");
insert into items values (1,456,10,5.55);
insert into items values (1,310,5,12.85);
insert into items values (1,744,60,250.95);
insert into items values (2,456,15,5.55);
insert into items values (2,310,2,12.85);
insert into stock values (456,"ASC","lightbulbs",5.55,5.0,"06/16/2003","ctn");
insert into stock values (310,"ASC","sink stoppers",12.85,11.57,"06/16/2003","grss");
insert into stock values (744,"ASC","faucets",250.95,225.86,"06/16/2003","6/bx");
insert into factory values ("ASC","Assoc. Std. Co.");
insert into factory values ("PHL","Phelps Lighting");
insert into state values ("IL","Illinois");
insert into state values ("IA","Iowa");
insert into state values ("WI","Wisconsin");


