Question
Convert the attributes listed below individually in steps a through c showing the data in 1 st Normal Form, 2 nd Normal Form and 3
Convert the attributes listed below individually in steps a through c 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, 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
B. 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
C. 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Larry Ellison Database Genius Of Oracle
Authors: Craig Peters
1st Edition
0766019748, 978-0766019744
