Computer Information Systems

Database Concepts

CIS377

Normalization Assignment 2:

Convert the attributes listed below individually in steps a through e 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 Number, Governor Name, Governor Political Party, Mayor ID Number, Mayor Name, Mayor Political Party

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

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

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

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