Question About ER Diagram
Not what you're looking for?
The State and Capital relations, shown in the attached figure 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).
- 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.
Purchase this Solution
Solution Summary
The answer is given in a Word attachment as a 176 word response with the ER diagram included.
Solution Preview
** Please see the attached file for the diagram **
1. The attribute of CountyName should be added into an additional table, named "Capital's county" table, which contains two columns, CountyName and CapitalName. The primary key is CountyName and CapitalName (Some county names may be ...
Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
C# variables and classes
This quiz contains questions about C# classes and variables.
Basic Networking Questions
This quiz consists of some basic networking questions.
Javscript Basics
Quiz on basics of javascript programming language.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.