Question: Clean and process this data. Reshaping: The raw data contains a multivalued field that must be resolved. Decomposition: The raw data contains a composite attribute

Clean and process this data. Reshaping: The raw data contains a multivalued field that must be resolved.
Decomposition: The raw data contains a composite attribute that must be
separated into its component parts.
Normalization: Break the raw data into 3 normalized (3NF) tables called STATES(containing information about each state), GOVERNORS(containing informationabout each governor), and OFFICES (tracking the previous elected office(s) held by each governor). Do not create any surrogate keys.
STATES table should have 50 rows (not counting header) and 3 columns. GOVERNORS should have 49 rows (not counting header) and 13 columns. OFFICES should have 65 rows (not counting header) and 2 columns.
GovernorID Name Ethnicity Birth Death Party StateCode StateName Suffrage Elected Vote TenureStart TenureEnd PreviousOffice
G-003 Lurleen Wallace White 9/19/19265/7/1968 Democrat 01 Alabama 1920 Y 0.6319671968
G-038 Kay E. Ivey White 10/15/1944 Republican 01 Alabama 1920 N 2017 Lieutenant Governor,Treasurer
G-029 Sarah H. Palin White 2/11/1964 Republican 02 Alaska 1913 Y 0.4820072009
G-010 Rose Mofford White 6/10/19229/15/2016 Democrat 04 Arizona 1912 N 19881991 Secretary of State
G-015 Jane Dee Hull White 8/8/19354/16/2020 Republican 04 Arizona 1912 N 19972002 Secretary of State,State Representative
G-021 Janet Napolitano White 11/29/1957 Democrat 04 Arizona 1912 Y 0.4620032008 Attorney General
G-030 Jan Brewer White 9/9/1944 Republican 04 Arizona 1912 N 20092014 Secretary of State,State Senator,State Representative
G-046 Katie Hobbs White 12/28/1969 Democrat 04 Arizona 1912 Y 0.52023 Secretary of State,State Senator,State Representative
G-047 Sarah Huckabee Sanders White 8/13/1982 Republican 05 Arkansas 1920 Y 0.632023
06 California 1911
08 Colorado 1893
G-004 Ella T. Grasso White 5/10/19192/5/1981 Democrat 09 Connecticut 1920 Y 0.619751980 US Representative,Secretary of State
G-026 Jodi Rell White 6/16/1946 Republican 09 Connecticut 1920 N 20042010 Lieutenant Governor,State Representative
G-018 Ruth Ann Minner White 1/17/193511/4/2021 Democrat 10 Delaware 1920 Y 0.620012008 Lieutenant Governor,State Senator,State Representative
12 Florida 1920
13 Georgia 1920
G-022 Linda Lingle White 6/4/1953 Republican 15 Hawaii 1920 Y 0.5220032010
16 Idaho 1896
17 Illinois 1920
18 Indiana 1920
G-039 Kimberly Reynolds White 8/4/1959 Republican 19 Iowa 1920 N 2017 Lieutenant Governor
G-011 Joan Finney White 2/12/19257/28/2001 Democrat 20 Kansas 1920 Y 0.4919911994 Treasurer
G-023 Kathleen Sebelius White 5/15/1948 Democrat 20 Kansas 1920 Y 0.5320032009 State Representative
G-040 Laura J. Kelly White 1/24/1950 Democrat 20 Kansas 1920 Y 0.482019 State Senator
G-007 Martha Layne Collins White 12/7/1936 Democrat 21 Kentucky 1920 Y 0.5519841987 Lieutenant Governor
G-027 Kathleen B. Blanco White 12/15/19428/18/2019 Democrat 22 Louisiana 1918 Y 0.5220042007 Lieutenant Governor,State Representative
G-041 Janet T. Mills White 12/30/1947 Democrat 23 Maine 1920 Y 0.52019 Attorney General,State Representative
24 Maryland 1920
G-019 Jane Maria Swift White 2/24/1965 Republican 25 Massachusetts 1920 N 20012002 Lieutenant Governor,State Senator
G-048 Maura Healey White 2/8/1971 Democrat 25 Massachusetts 1920 Y 0.642023 Attorney General
G-024 Jennifer Granholm White 2/5/1959 Democrat 26 Michigan 1918 Y 0.5120032010 Attorney General
G-042 Gretchen E. Whitmer White 8/23/1971 Democrat 26 Michigan 1918 Y 0.532019 State Senator,State Representative
27 Minnesota 1920
28 Mississippi 1920
29 Missouri 1920
G-020 Judy Martz White 7/28/194310/30/2017 Republican 30 Montana 1914 Y 0.5120012004 Lieutenant Governor
G-009 Kay A. Orr White 1/2/1939 Republican 31 Nebraska 1920 Y 0.5319871990 Treasurer
32 Nevada 1920
G-006 Vesta Roy White 3/26/19252/9/2002 Republican 33 New Hampshire 1920 N 19821983 State Senator
G-016 Jeanne Shaheen White 1/28/1947 Democrat 33 New Hampshire 1920 Y 0.5719972002 State Senator
G-035 Maggie Hassan White 2/27/1958 Democrat 33 New Hampshire 1920 Y 0.5220132016 State Senator
G-014 Christine Todd Whitman White 9/26/1946 Republican 34 New Jersey 1920 Y 0.4919942001
G-032 Susana Martinez Latina 7/14/1959 Republican 35 New Mexico 1920 Y 0.5320112018
G-043 Michelle Lujan Grisham Latina 10/24/1959 Democrat 35 New Mexico 1920 Y 0.572019 US Representative,Secretary of Health
G-045 Kathy C. Hochul White 8/27/1958 Democrat 36 New York 1917 N 2021 Lieutenant Governor,US Representative
G-031 Beverly M. Perdue White 1/14/1947 Democrat 37 North Carolina 1920 Y 0.520092012 Lieutenant Governor,State Senator,State Representative
38 North Dakota 1917
G-017 Nancy P. Hollister White 5/22/1949 Republican 39 Ohio 1920 N 19981999 Lieutenant Governor
G-033 M

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!