[ Skip menu ]

• Introduction

Basic UML & SQL

• Models

• Classes & schemes

• Rows & tables

• Associations

• Keys

UML design

• Many-to-many

- Notecards

- Students and classes

- Authors

- Auto repair

- Video rental

- Santa Claus list

• 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: students and classes

If you are using this Web site in a class at a university, you are probably interested in what grade you will get in the class.

• You will need to model the students and the (university) classes, their attributes, and the relationship between them. Be sure to show where the grade should be recorded.

• Describe each class in English.

• Draw the class diagram, including association classes if required.

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