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 $(3$NF$)$ 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\mathrm{.}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\mathrm{.}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\mathrm{.}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\mathrm{.}52023$ Secretary of State,State Senator,State Representative

G$-047$ Sarah Huckabee Sanders White $8/13/1982$ Republican $05$ Arkansas $1920$ Y $0\mathrm{.}632023$

$06$ California $1911$

$08$ Colorado $1893$

G$-004$ Ella T$.$ Grasso White $5/10/19192/5/1981$ Democrat $09$ Connecticut $1920$ Y $0\mathrm{.}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\mathrm{.}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\mathrm{.}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\mathrm{.}4919911994$ Treasurer

G$-023$ Kathleen Sebelius White $5/15/1948$ Democrat $20$ Kansas $1920$ Y $0\mathrm{.}5320032009$ State Representative

G$-040$ Laura J$.$ Kelly White $1/24/1950$ Democrat $20$ Kansas $1920$ Y $0\mathrm{.}482019$ State Senator

G$-007$ Martha Layne Collins White $12/7/1936$ Democrat $21$ Kentucky $1920$ Y $0\mathrm{.}5519841987$ Lieutenant Governor

G$-027$ Kathleen B$.$ Blanco White $12/15/19428/18/2019$ Democrat $22$ Louisiana $1918$ Y $0\mathrm{.}5220042007$ Lieutenant Governor,State Representative

G$-041$ Janet T$.$ Mills White $12/30/1947$ Democrat $23$ Maine $1920$ Y $0\mathrm{.}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\mathrm{.}642023$ Attorney General

G$-024$ Jennifer Granholm White $2/5/1959$ Democrat $26$ Michigan $1918$ Y $0\mathrm{.}5120032010$ Attorney General

G$-042$ Gretchen E$.$ Whitmer White $8/23/1971$ Democrat $26$ Michigan $1918$ Y $0\mathrm{.}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\mathrm{.}5120012004$ Lieutenant Governor

G$-009$ Kay A$.$ Orr White $1/2/1939$ Republican $31$ Nebraska $1920$ Y $0\mathrm{.}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\mathrm{.}5719972002$ State Senator

G$-035$ Maggie Hassan White $2/27/1958$ Democrat $33$ New Hampshire $1920$ Y $0\mathrm{.}5220132016$ State Senator

G$-014$ Christine Todd Whitman White $9/26/1946$ Republican $34$ New Jersey $1920$ Y $0\mathrm{.}4919942001$

G$-032$ Susana Martinez Latina $7/14/1959$ Republican $35$ New Mexico $1920$ Y $0\mathrm{.}5320112018$

G$-043$ Michelle Lujan Grisham Latina $10/24/1959$ Democrat $35$ New Mexico $1920$ Y $0\mathrm{.}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\mathrm{.}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