Exercise: video rental

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.