Question
The U.S. government wants to keep track of information about states, governors, cities, and mayors. In addition, it wants to maintain data on the various
The U.S. government wants to keep track of information about states, governors, cities, and mayors. In addition, it wants to maintain data on the various federal agencies and the annual grants each agency gives to the individual states. Each federal agency is headed by an administrator. Agency names and state names are unique but city names are unique only within a state. (2 parts to this)
For each of the following tables (shown below as tables a-e),
first write which normal form it in currently (as 1NF, 2NF, or 3NF).
Then, reconstruct those tables that are currently in 1 NF or 2 NF as well structured 3NF tables. Primary key attributes are underlined. Do not assume any functional dependencies other than those shown.
a. State, City, Governor Name, Mayor ID Number, Mayor Name, Mayor Telephone
b. State, City, Mayor Name, Mayor Telephone
c. State, City, Federal Agency, Governor Name, Administrator, Annual Grant
d. State, City, Governor Name, State Flower, Mayor, Telephone
e. State, City, City Hall Address, Mayor ID Number, Mayor Name, Mayor Telephone
The attributes and functional dependencies in this environment are listed below for your convenience. Please refer to them.
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