You are designing a database for a video rental store. To start, you need the part of the system that will allow a customer to check out a group of videos and receive an invoice that lists them along with the cost and the date they are due.

• Assume that the word “video” means either a now-old-fashioned VHS tape or a DVD (or any other media), which you probably want to identify in the model. The physical video will be a copy of a movie, TV show, or other material, which you don’t have to model here.

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