Simple Database design

you should have something like this

Exercise: Cities and States Part of a database that you are developing will contain information about cities and states in the United States. Each city is located in only one state. (Texarkana, Texas is a different city than Texarkana, Arkansas.) The name of the state uniquely identifies it. Each state also has a separate, unique state code. For instance, the state code for California is CA, but Hawaii has the state code of Hl. . Describe each class in English. Draw the class diagram. Describe each association in English (both directions). Draw the relation scheme. o o o o Exercise: Cities and States Part of a database that you are developing will contain information about cities and states in the United States. Each city is located in only one state. (Texarkana, Texas is a different city than Texarkana, Arkansas.) The name of the state uniquely identifies it. Each state also has a separate, unique state code. For instance, the state code for California is CA, but Hawaii has the state code of Hl. . Describe each class in English. Draw the class diagram. Describe each association in English (both directions). Draw the relation scheme. o o o o