I need help with this homework ASAP!!! I have done research and just cant wrap my head around it correctly! The state and capital relations, shown in the figure below, are described as follows: State (StateAbbrev, StateName, EnteredUnionOrder, StateBird, StatePopulation) Capital (CapitalName, State Abbrev, YearDesignated, PhoneAreaCode, CapitalPopulation) Foreign key: StateAbbrev to State relation StateAbbrev StateName EnteredUnionOrder StateBird StatePopulation CT Connecticut 5 American robin 3,287,116 MI Michigan 26 robin 9,295,297 SD South Dakota 40 pheasant 696,004 TN Tennessee 16 mockingbird 4,877,185 TX Texas 25 mockingbird 16,986,510 CapitalName StateAbbrev YearDesignated CapitalPopulation Austin TX 1845 465,622 Hartford CT 1662 139,739 Lansing MI 1847 127,321 Nashville TN 1843 488,374 Pierre SD 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 databases entities. You may use Microsoft Word, PowerPoint, or Visio to create your diagram.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]