
drop table weatherCities cascade constraints;

create table weatherCities (
  region varchar2(30),
  state  varchar2(30),
  city   varchar2(30),
  primary key (region,state,city)
);

insert into weatherCities values ('Northeast','Maryland','Annapolis');
insert into weatherCities values ('Northeast','Maryland','Baltimore');
insert into weatherCities values ('Northeast','Maryland','Gaithersburg');
insert into weatherCities values ('Northeast','Maryland','Rockville');

insert into weatherCities values ('Northeast','Massachusetts','Boston');
insert into weatherCities values ('Northeast','Massachusetts','Cambridge');
insert into weatherCities values ('Northeast','Massachusetts','Springfield');
insert into weatherCities values ('Northeast','Massachusetts','Worcester');

insert into weatherCities values ('Northeast','New York','Buffalo');
insert into weatherCities values ('Northeast','New York','New York');
insert into weatherCities values ('Northeast','New York','Albany');
insert into weatherCities values ('Northeast','New York','Long Beach');

insert into weatherCities values ('Northeast','New Jersey','Paterson');
insert into weatherCities values ('Northeast','New Jersey','Newark');
insert into weatherCities values ('Northeast','New Jersey','Jersey City');

insert into weatherCities values ('Northeast','Pennsylvania','Philadelphia');
insert into weatherCities values ('Northeast','Pennsylvania','Pittsburgh');
insert into weatherCities values ('Northeast','Pennsylvania','Allentown');

insert into weatherCities values ('Southeast','Florida','Jacksonville');
insert into weatherCities values ('Southeast','Florida','St. Petersburg');
insert into weatherCities values ('Southeast','Florida','Miami');
insert into weatherCities values ('Southeast','Florida','Orlando');

insert into weatherCities values ('Southeast','Georgia','Columbus');
insert into weatherCities values ('Southeast','Georgia','Atlanta');
insert into weatherCities values ('Southeast','Georgia','Macon');
insert into weatherCities values ('Southeast','Georgia','Roswell');

insert into weatherCities values ('Southeast','Tennessee','Chattanooga');
insert into weatherCities values ('Southeast','Tennessee','Knoxville');
insert into weatherCities values ('Southeast','Tennessee','Memphis');
insert into weatherCities values ('Southeast','Tennessee','Nashville');

insert into weatherCities values ('Southeast','Virginia','Virginia Beach');
insert into weatherCities values ('Southeast','Virginia','Portsmouth');
insert into weatherCities values ('Southeast','Virginia','Richmond');
insert into weatherCities values ('Southeast','Virginia','Norfolk');

insert into weatherCities values ('Southeast','Alabama','Birmingham');
insert into weatherCities values ('Southeast','Alabama','Montgomery');
insert into weatherCities values ('Southeast','Alabama','Mobile');
insert into weatherCities values ('Southeast','Alabama','Huntsville');

insert into weatherCities values ('Midwest','Illinois','Chicago');
insert into weatherCities values ('Midwest','Illinois','Rockford');
insert into weatherCities values ('Midwest','Illinois','Peoria');
insert into weatherCities values ('Midwest','Illinois','Joliet');

insert into weatherCities values ('Midwest','Indiana','Fort Wayne');
insert into weatherCities values ('Midwest','Indiana','Indianapolis');
insert into weatherCities values ('Midwest','Indiana','South Bend');
insert into weatherCities values ('Midwest','Indiana','Evansville');

insert into weatherCities values ('Midwest','Iowa','Davenport');
insert into weatherCities values ('Midwest','Iowa','Sioux City');
insert into weatherCities values ('Midwest','Iowa','Des Moines');
insert into weatherCities values ('Midwest','Iowa','Cedar Rapids');

insert into weatherCities values ('Midwest','Kansas','Kansas City');
insert into weatherCities values ('Midwest','Kansas','Overland Park');
insert into weatherCities values ('Midwest','Kansas','Wichita');
insert into weatherCities values ('Midwest','Kansas','Topeka');

insert into weatherCities values ('Midwest','Michigan','Ann Arbor');
insert into weatherCities values ('Midwest','Michigan','Detroit');
insert into weatherCities values ('Midwest','Michigan','Grand Rapids');
insert into weatherCities values ('Midwest','Michigan','Flint');

insert into weatherCities values ('West','Arizona','Scottsdale');
insert into weatherCities values ('West','Arizona','Mesa');
insert into weatherCities values ('West','Arizona','Phoenix');
insert into weatherCities values ('West','Arizona','Tucson');

insert into weatherCities values ('West','Nevada','Las Vegas');
insert into weatherCities values ('West','Nevada','Paradise');
insert into weatherCities values ('West','Nevada','Sunrise Manor');

insert into weatherCities values ('West','California','Los Angeles');
insert into weatherCities values ('West','California','Sacramento');
insert into weatherCities values ('West','California','San Diego');
insert into weatherCities values ('West','California','San Francisco');
insert into weatherCities values ('West','California','Santa Barbara');

insert into weatherCities values ('West','New Mexico','Albuquerque');
insert into weatherCities values ('West','New Mexico','Santa Fe');
insert into weatherCities values ('West','New Mexico','Las Cruces');

insert into weatherCities values ('Northwest','Utah','Salt Lake City');
insert into weatherCities values ('Northwest','Utah','West Valley City');
insert into weatherCities values ('Northwest','Utah','Sandy');

insert into weatherCities values ('Northwest','Washington','Seattle');
insert into weatherCities values ('Northwest','Washington','Tacoma');
insert into weatherCities values ('Northwest','Washington','Vancouver');
insert into weatherCities values ('Northwest','Washington','Spokane');

insert into weatherCities values ('Northwest','Oregon','Portland');
insert into weatherCities values ('Northwest','Oregon','Salem');
insert into weatherCities values ('Northwest','Oregon','Eugene');

insert into weatherCities values ('Northwest','Montana','Billings');
insert into weatherCities values ('Northwest','Montana','Missoula');
insert into weatherCities values ('Northwest','Montana','Great Falls');

insert into weatherCities values ('Northwest','Idaho','Boise');
insert into weatherCities values ('Northwest','Idaho','Nampa');
insert into weatherCities values ('Northwest','Idaho','Pocatello');

insert into weatherCities values ('Northwest','Wyoming','Cheyenne');
insert into weatherCities values ('Northwest','Wyoming','Casper');
insert into weatherCities values ('Northwest','Wyoming','Laramie');


