This is a simple bid request I just don't have time to do,
Here are the specifics...
The State and Capital relations, shown in the graphic attached are described as follows:
State (StateAbbrev, StateName, EnteredUnionOrder, StateBird, StatePopulation)
Capital (Capital Name, State Abbrev, YearDesignated, PhoneAreaCode, CapitalPopulation)
Foreign key: StateAbbrev to State relation
Add the attribute CountyName for the county or counties containing the state capital to this database, justify where you placed it (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 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.
I need A paragraph justifying where you would add the CountyName attribute and why.
• An ER Diagram with relationships.
• NOTE: Re-creating this in Access is not necessary.
The paragraph and work should be done as a word document.