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; just as Long Beach, CA is different from Long Beach, NY and these are different than Long Beach, WA).

Model the information provided by completing the following steps; the steps have been summarized here, but the more detailed steps, please see the patients and blood samples problem.

  1. Identify and describe each class in English.
  2. Draw the UML class diagram, only the class names
  3. Determine the relationships between the classes you identified, model the relationships as associations in the UML class diagram.
  4. Specify the attributes and their data types for each class.
  5. Map the UML class diagram to the relational model

The solution to this exercise may be discussed in class by your instructor or posted online at a later date.