Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

UMUC Haircuts Appointment Process Individual Needs Appointment for Hair Styling Calls UMUC Haircuts and requests appointment Drives to UMUC Haircuts 1 Employee greets customer and asks customer last...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

BA630 - Systems Analysis & Design Exercise (Team Project) Maximum Word Count: 4000 words The purpose of this project is to pull several ideas together that we have covered throughout the semester and...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

Final Paper Instructions/Guidelines: The final paper must be a minimum of 5 pages and a maximum of 7 pages in APA format. You can find APA guidelines in the Week Six folder under final paper tips....

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

Two Discussion Questions. A minimum of 200 words per question. Both questions are attached to the word document and each chapter to both questions are attached to the PDF. Any references/citations...

The Sports Associates Vending Company supplies refreshments at a baseball stadium and must plan for the possibility of a World Series contest. In the accompanying frequency table (based on past...

Yellow Ltd, a food manufacturer, is reviewing its operation for March 2021. The company produces only one product, called YM. The following standard revenue and cost data per unit of the product is...

Right before the stock market opens, from Bloomberg News you heard that the Dow futures with one - month maturity is quoted 3 percent higher than yesterday's settlement price. Part of the reason is...

PASSAGE Karan, a rural boy, identifies the potential of Organic Farming in the village. He meets the zonal agricultural officer, who, looking at the determination of this 2 0 years old, helps him...

Economist John Taylor has suggested that the Fed use the following rule for choosing its target for the federal funds interest rate (r): r = 2% + + 12 (y y*) / y* + 12 ( *), where is the average...

Suppose banks install automatic teller machines on every block and, by making cash readily available, reduce the amount of money people want to hold. a. Assume the Fed does not change the money...

Consider two policiesa tax cut that will last for only 1 year and a tax cut that is expected to be permanent. Which policy will stimulate greater spending by consumers? Which policy will have the...