[ Skip menu ]

• Introduction

Basic UML & SQL

• Models

• Classes & schemes

• Rows & tables

• Associations

- Patients

- Cities / states

- Library books

• Keys

UML design

• Many-to-many

• Many-to-many 2

• Subkeys

• Repeated attributes

• Multivalued attributes

• Domains

• Enumerated domains

• Subclasses

• Aggregation

• Recursive associations

• Normalization

SQL technique

• Queries

• DDL & DML

• Join

• Multiple joins

• Join types

• Functions

• Subqueries

• Union & minus

• Views & indexes

[ Contents ]

[ Glossary ]

[ Change log ]

Copyright © 2002–2006, Tom Jewett [ see notice ]

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.)

• Describe each class in English.

• Draw the class diagram.

• Describe each association in English (both directions).

• Draw the relation scheme.

The solution to this exercise will be discussed in class or posted online at a later date.

Copyright © 2002–2006, by Tom Jewett. Links to this site are welcome and encouraged. Individual copies may be printed for non-commercial classroom or personal use; however, this material may not be reposted to other web sites or newsgroups, or included in any printed or electronic publication, whether modified or not, without specific permission from the author.