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.
- Identify and describe each class in English.
- Draw the UML class diagram, only the class names
- Determine the relationships between the classes you identified, model the relationships as associations in the UML class diagram.
- Specify the attributes and their data types for each class.
- 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.