create table addresses (
 id number,
 firstname varchar2(10),
 lastname varchar2(10),
 address varchar2(30),
 city varchar2(30),
 stateorprovince varchar2(20),
 postalcode varchar(15),
 country varchar(15),
 emailaddress varchar(20),
 homephone varchar(15),
 faxnumber varchar(15) 
);
 
