Can you help me with this question and answering the parts to it like numbeer 1,2 and 3 can you do it step by step and can you label the numbers as well so it will be easier to follow along. The photo is together I just could fit it into one page.questions:1) Begin by creating a universal relation containing all the attributes. Select a primary key for the relation that will insure that the universal relation is in first normal form.2) Decompose this table into additional tables as needed to put the set of tables into second normal form.3) It is possible that none, some , or all of thte tables created in step are already in third normal form, which, if any, of the tables are already in third normal form. If any of the tables are not yet in third normal form,decompose these tables so that the resulting tables are in third normal form. Consider the following information for a U.S. government agency that is responsible forawarding grants to U.S. cities and states. The agency wants to keep some information about thecities and states, as well as information about which of its departments has issued grants to thevarious cities and states for the current year. Both department names and state names areunique, but city names are only unique within a given state. Each state is run by a governor, andthe agency has assigned a unique ID to each governo. Each city is run by a mayor, and theagency has assigned a unique ID to each mayor. Each department in the agency is run by adepartment head. Note that it is possible for a city to receive grants from different departmentsin the same year.More specifically, the agency has determined that it is interested in the following attributes.State (name)Governor ID (number)Governor NameState FlowerState BirdCityMayor ID (number)Mayor NameAddress of Mayor's OfficeMayor's TelephoneDepartment (issuing grant)Department Head (name)Annual Grant Amount After discussion with the agency, it was determined that the following functional dependencieshold for the proposed database.StateStateStateStateState, CityState, CityState, CityState, CityGovernor IDMayor IDMayor IDMayor IDDepartmentState, City, Department ->Governor IDGovernor NameState FlowerState BirdMayor IDMayor NameMayor AddressMayor PhoneGovernor NameMayor NameMayor AddressMayor PhoneDepartment HeadGrant Amount

The question asks to design a normalized relational database for a U.S. government agency managing…

Answered: Can you help me with this question and…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Can you help me with this question and answering the parts to it like numbeer 1,2 and 3 can you do it step by step and can you label the numbers as well so it will be easier to follow along. The photo is together I just could fit it into one page.

questions:

1) Begin by creating a universal relation containing all the attributes. Select a primary key for the relation that will insure that the universal relation is in first normal form.

2) Decompose this table into additional tables as needed to put the set of tables into second normal form.

3) It is possible that none, some , or all of thte tables created in step are already in third normal form, which, if any, of the tables are already in third normal form. If any of the tables are not yet in third normal form,decompose these tables so that the resulting tables are in third normal form.

Consider the following information for a U.S. government agency that is responsible for
awarding grants to U.S. cities and states. The agency wants to keep some information about the
cities and states, as well as information about which of its departments has issued grants to the
various cities and states for the current year. Both department names and state names are
unique, but city names are only unique within a given state. Each state is run by a governor, and
the agency has assigned a unique ID to each governo. Each city is run by a mayor, and the
agency has assigned a unique ID to each mayor. Each department in the agency is run by a
department head. Note that it is possible for a city to receive grants from different departments
in the same year.
More specifically, the agency has determined that it is interested in the following attributes.
State (name)
Governor ID (number)
Governor Name
State Flower
State Bird
City
Mayor ID (number)
Mayor Name
Address of Mayor's Office
Mayor's Telephone
Department (issuing grant)
Department Head (name)
Annual Grant Amount

After discussion with the agency, it was determined that the following functional dependencies
hold for the proposed database.
State
State
State
State
State, City
State, City
State, City
State, City
Governor ID
Mayor ID
Mayor ID
Mayor ID
Department
State, City, Department ->
Governor ID
Governor Name
State Flower
State Bird
Mayor ID
Mayor Name
Mayor Address
Mayor Phone
Governor Name
Mayor Name
Mayor Address
Mayor Phone
Department Head
Grant Amount

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions