Reference no: EM131143436
Using MySQL Workbench build a database that:
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. The attributes and functional dependencies in this environment are as follows:
Attributes
State
Governor ID Number
Governor Name
State Flower
City
Mayor ID Number
Mayor Name
City Hall Address
Mayor Telephone
Federal Agency
Administrator
Annual Grant
Functional Dependencies
State Governor ID Number
State Governor Name
State State Flower
State, City Mayor ID Number
State, City Mayor Name
State, City City Hall Address
State, City Mayor Telephone
Mayor ID Number Mayor Name
Mayor ID Number Mayor Telephone
Federal Agency Administrator
State, City, Federal Agency Annu
For each of the following tables, first write the table's current normal form (as 1NF, 2NF, or 3NF). Then, reconstruct those tables that are currently in 1NF 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.
Write an equation of the tangent line to the graph
: Write an equation of the tangent line to the graph of a differentiable function (y as a function of x) which satisfies the relation x2 + 4xy + y2 = 13 at the point (2,1)
|
Why should corporations have a counter intelligence function
: Why should corporations have a counter intelligence function? - What impact does corporate espionage have on the security and well-being of the United States?
|
Determine the height of a radio tower
: Determine the height of a radio tower, which appears on a vertical photograph for the following conditions of flying height above the tower base H, distance on the photograph from principal point to tower base rb, and distance from principal point..
|
Sales representative for company that encourages staff
: You are a sales representative for a company that encourages staff to log time in the field and away from the office. You are expected to begin and end your day at the office. You notice that each day when you arrive and return another co-worker is a..
|
Maintain data on the various federal agencies
: 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.
|
About solving the problem using this systematic approach
: When faced with a problem, what do you do to solve it? This assignment asks you to apply a six-step to problem solving process to a specific problem scenario. You will write a paper that presents a synthesis of your ideas about solving the problem us..
|
Find the average value of your account
: Suppose you deposit $6000 at 7% interest compounded continuously. Find the average value of your account during the first 2 years. Find the average value of the function f(x) = 5x2 on the interval 0 ≤ x ≤ 4
|
Important steps in the strategic sourcing process
: There are 6 important steps in the strategic sourcing process: 1. Access Opportunities, 2. Profile internally & externally, 3. Develop the Sourcing Strategy, 4. Screen Suppliers & Create Selection Criteria, 5. Conduct Supplier Selection, and 6. Negot..
|
Calculate the area in acres of triangle abd
: On the photograph of Problem 27.12, the image d of a third point D appears.Its elevation is hD = 1195 ft, and its photo coordinates are xd = 56.86 mm and yd = 63.12 mm. Calculate the area, in acres, of triangle ABD.
|