Data Modeling and Design

I need help with this homework ASAP!!! I have done research and just can’t wrap my head around it correctly!

  

The state and capital relations, shown in the figure below, are described as follows:

• State (

  StateAbbrev

  ,

  Save Time On Research and Writing

  Hire a Pro to Write You a 100% Plagiarism-Free Paper.

  Get My Paper

  StateName

  ,

  EnteredUnionOrder

  ,

  StateBird

  ,

  StatePopulation

  )

• Capital (

  CapitalName

  , State Abbrev,

  YearDesignated

  , PhoneAreaCode,

  CapitalPopulation

  )

• Foreign key: StateAbbrev to State relation

StateAbbrevStateNameEnteredUnionOrderStateBirdStatePopulationCT

5

MI

26robin

SD

40

TN

16

TX

25mockingbird

Connecticut	American	robin	3,287,116
Michigan	9,295,297
South Dakota	pheasant	696,004
Tennessee		mockingbird	4,877,185
Texas	16,986,510

CapitalNameStateAbbrevYearDesignatedCapitalPopulation

TX

CT

MI

TN

SD

Austin	1845	465,622
Hartford	1662	139,739
Lansing	1847	127,321
Nashville	1843	488,374
Pierre	1889	12,906

Add the attribute “CountyName” for the county or counties containing the state capital to this database. Justify where you placed the attribute (that is, in an existing relation or in a new one), and draw the entity-relationship diagram for all of the entities using the AutoShapes in Microsoft Word.

Note: The counties for the state capitals shown in the figure above are as follows:

• Travis and Williamson Counties for Austin, TX
• Hartford County for Hartford, CT
• Clinton, Eaton, and Ingham Counties for Lansing, MI
• Davidson County for Nashville, TN
• Hughes County for Pierre, SD

Assignment Guidelines:

• In a Word document, explain where you would add the attribute CountyName for the county or counties containing the state capital to this simple database. Explain your solution.
• Draw an entity-relationship diagram for all of the database’s entities. You may use Microsoft Word, PowerPoint, or Visio to create your diagram.