CREATE TABLE hudsonu.region(
State_Code CHAR(2) NOT NULL PRIMARY KEY
,State_Name VARCHAR(20) NOT NULL
,Region CHAR(9) NOT NULL
,Division VARCHAR(18) NOT NULL
);
begin
INSERT INTO hudsonu.region VALUES ('AK','Alaska','West','Pacific');
INSERT INTO hudsonu.region VALUES ('AL','Alabama','South','East South Central');
INSERT INTO hudsonu.region VALUES ('AR','Arkansas','South','West South Central');
INSERT INTO hudsonu.region VALUES ('AZ','Arizona','West','Mountain');
INSERT INTO hudsonu.region VALUES ('CA','California','West','Pacific');
INSERT INTO hudsonu.region VALUES ('CO','Colorado','West','Mountain');
INSERT INTO hudsonu.region VALUES ('CT','Connecticut','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('DC','District of Columbia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('DE','Delaware','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('FL','Florida','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('GA','Georgia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('HI','Hawaii','West','Pacific');
INSERT INTO hudsonu.region VALUES ('IA','Iowa','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('ID','Idaho','West','Mountain');
INSERT INTO hudsonu.region VALUES ('IL','Illinois','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('IN','Indiana','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('KS','Kansas','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('KY','Kentucky','South','East South Central');
INSERT INTO hudsonu.region VALUES ('LA','Louisiana','South','West South Central');
INSERT INTO hudsonu.region VALUES ('MA','Massachusetts','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('MD','Maryland','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('ME','Maine','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('MI','Michigan','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('MN','Minnesota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('MO','Missouri','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('MS','Mississippi','South','East South Central');
INSERT INTO hudsonu.region VALUES ('MT','Montana','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NC','North Carolina','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('ND','North Dakota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('NE','Nebraska','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('NH','New Hampshire','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('NJ','New Jersey','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('NM','New Mexico','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NV','Nevada','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NY','New York','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('OH','Ohio','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('OK','Oklahoma','South','West South Central');
INSERT INTO hudsonu.region VALUES ('OR','Oregon','West','Pacific');
INSERT INTO hudsonu.region VALUES ('PA','Pennsylvania','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('RI','Rhode Island','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('SC','South Carolina','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('SD','South Dakota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('TN','Tennessee','South','East South Central');
INSERT INTO hudsonu.region VALUES ('TX','Texas','South','West South Central');
INSERT INTO hudsonu.region VALUES ('UT','Utah','West','Mountain');
INSERT INTO hudsonu.region VALUES ('VA','Virginia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('VT','Vermont','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('WA','Washington','West','Pacific');
INSERT INTO hudsonu.region VALUES ('WI','Wisconsin','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('WV','West Virginia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('WY','Wyoming','West','Mountain');
end;
/
State_Code CHAR(2) NOT NULL PRIMARY KEY
,State_Name VARCHAR(20) NOT NULL
,Region CHAR(9) NOT NULL
,Division VARCHAR(18) NOT NULL
);
begin
INSERT INTO hudsonu.region VALUES ('AK','Alaska','West','Pacific');
INSERT INTO hudsonu.region VALUES ('AL','Alabama','South','East South Central');
INSERT INTO hudsonu.region VALUES ('AR','Arkansas','South','West South Central');
INSERT INTO hudsonu.region VALUES ('AZ','Arizona','West','Mountain');
INSERT INTO hudsonu.region VALUES ('CA','California','West','Pacific');
INSERT INTO hudsonu.region VALUES ('CO','Colorado','West','Mountain');
INSERT INTO hudsonu.region VALUES ('CT','Connecticut','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('DC','District of Columbia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('DE','Delaware','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('FL','Florida','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('GA','Georgia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('HI','Hawaii','West','Pacific');
INSERT INTO hudsonu.region VALUES ('IA','Iowa','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('ID','Idaho','West','Mountain');
INSERT INTO hudsonu.region VALUES ('IL','Illinois','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('IN','Indiana','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('KS','Kansas','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('KY','Kentucky','South','East South Central');
INSERT INTO hudsonu.region VALUES ('LA','Louisiana','South','West South Central');
INSERT INTO hudsonu.region VALUES ('MA','Massachusetts','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('MD','Maryland','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('ME','Maine','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('MI','Michigan','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('MN','Minnesota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('MO','Missouri','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('MS','Mississippi','South','East South Central');
INSERT INTO hudsonu.region VALUES ('MT','Montana','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NC','North Carolina','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('ND','North Dakota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('NE','Nebraska','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('NH','New Hampshire','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('NJ','New Jersey','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('NM','New Mexico','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NV','Nevada','West','Mountain');
INSERT INTO hudsonu.region VALUES ('NY','New York','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('OH','Ohio','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('OK','Oklahoma','South','West South Central');
INSERT INTO hudsonu.region VALUES ('OR','Oregon','West','Pacific');
INSERT INTO hudsonu.region VALUES ('PA','Pennsylvania','Northeast','Middle Atlantic');
INSERT INTO hudsonu.region VALUES ('RI','Rhode Island','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('SC','South Carolina','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('SD','South Dakota','Midwest','West North Central');
INSERT INTO hudsonu.region VALUES ('TN','Tennessee','South','East South Central');
INSERT INTO hudsonu.region VALUES ('TX','Texas','South','West South Central');
INSERT INTO hudsonu.region VALUES ('UT','Utah','West','Mountain');
INSERT INTO hudsonu.region VALUES ('VA','Virginia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('VT','Vermont','Northeast','New England');
INSERT INTO hudsonu.region VALUES ('WA','Washington','West','Pacific');
INSERT INTO hudsonu.region VALUES ('WI','Wisconsin','Midwest','East North Central');
INSERT INTO hudsonu.region VALUES ('WV','West Virginia','South','South Atlantic');
INSERT INTO hudsonu.region VALUES ('WY','Wyoming','West','Mountain');
end;
/