Convert the attributes listed below individually in steps a through g showing the data in 1^st Normal Form, 2^nd Normal Form and 3^rd Normal Form.

Use Excel or a Table in Word to show the data listed below representing current tables. Use a single underline for the primary keys and a double underline for the foreign keys.

a. State, City, Governor ID, Governor Name, Governor Political Party, Mayor ID Number, Mayor Name, Mayor Political Party

b. State, City, Governor ID, Governor Name, Governor Political Party, Governor Telephone Number, Mayor ID Number, Mayor Name, Mayor Political Party, Mayor Telephone Number

c. State, City, Governor ID, Governor Name, Governor Political Party, Governor Telephone Number, Mayor ID Number, Mayor Name, Mayor Political Party, Mayor Telephone Number, Federal Agency ID, Federal Agency

d. State, City, Governor ID, Governor Name, Governor Political Party, Governor Telephone Number, Governor Year Elected, State Flower, Mayor ID Number, Mayor Name, Mayor Political Party, Mayor Telephone Number, Mayor Year Elected, Federal Agency ID, Federal Agency

e. State, City, Governor ID, Governor Name, Governor Political Party, Governor Telephone Number, Governor Year Elected, State Flower, Mayor ID Number, Mayor Name, Mayor Political Party, Mayor Telephone Number, Mayor Year Elected, City Hall Address, Federal Agency ID, Federal Agency, Administrator ID, Administrator Name, Annual Grant Amount

f. State, City, Governor ID, Governor Name, Political Party Code, Governor Political Party, Governor Telephone Number, Governor Year Elected, State Flower, Mayor ID Number, Mayor Name, Political Party Code, Mayor Political Party, Mayor Telephone Number, Mayor Year Elected, City Hall Address, Federal Agency ID, Federal Agency, Administrator ID, Administrator Name, Annual Grant Amount

g. State, City, Governor ID, Governor Name, Political Party Code, Governor Political Party, Governor Telephone Number, Governor Year Elected, State Flower, Mayor ID Number, Mayor Name, Political Party Code, Mayor Political Party, Mayor Telephone Number, Mayor Year Elected, City Hall Address, Federal Agency ID, Federal Agency, Administrator ID, Administrator Name, Year of Annual Grant, Annual Grant Amount.