Convert the attributes listed below “individually” in steps a through g showing
ID: 3734386 • Letter: C
Question
Convert the attributes listed below “individually” in steps a through g showing the data in 1st Normal Form, 2nd Normal Form and 3rd 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.
Explanation / Answer
Answer.)
a.)
State
City
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
1NF
State
City
Governor ID
Mayor ID Number
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
2NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
Address ID
State
City
3NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Political Party ID
Mayor ID Number
Mayor Name
Political Party ID
Address ID
State
City
Political Party ID
Political Party Name
b.)
State
City
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
1NF
State
City
Governor ID
Mayor ID Number
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
2NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
Address ID
State
City
3NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Political Party ID
Mayor ID Number
Mayor Name
Political Party ID
Address ID
State
City
Political Party ID
Political Party Name
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
1NF
State
City
Governor ID
Mayor ID Number
Federal Agency ID
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
2NF
Governor ID
Mayor ID Number
Address ID
Federal Agency ID
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
Address ID
State
City
Federal Agency ID
Federal Agency
3NF
Governor ID
Mayor ID Number
Address ID
Federal Agency ID
Governor ID
Governor Name
Political Party ID
Governor Telephone Number
Mayor ID Number
Mayor Name
Political Party ID
Mayor Telephone Number
Address ID
State
City
Political Party ID
Political Party Name
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
1NF
State
City
Governor ID
Mayor ID Number
Federal Agency ID
State Flower
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Governor Year Elected
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
Mayor Year Elected
Federal Agency ID
Federal Agency
2NF
Governor ID
Mayor ID Number
Address ID
Federal Agency ID
Governor ID
Governor Name
Governor Political Party
Governor Telephone Number
Governor Year Elected
Mayor ID Number
Mayor Name
Mayor Political Party
Mayor Telephone Number
Mayor Year Elected
Address ID
State
City
State Flower
Federal Agency ID
Federal Agency
3NF
Governor ID
Mayor ID Number
Address ID
Federal Agency ID
Governor ID
Governor Name
Political Party ID
Governor Telephone Number
Governor Year Elected
Mayor ID Number
Mayor Name
Political Party ID
Mayor Telephone Number
Mayor Year Elected
Address ID
State
City
State Flower
Political Party ID
Political Party Name
Federal Agency ID
Federal Agency
State
City
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
1NF
State
City
Governor ID
Mayor ID Number
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
2NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Governor Political Party
Mayor ID Number
Mayor Name
Mayor Political Party
Address ID
State
City
3NF
Governor ID
Mayor ID Number
Address ID
Governor ID
Governor Name
Political Party ID
Mayor ID Number
Mayor Name
Political Party ID
Address ID
State
City
Political Party ID
Political Party Name