Computer Science 455

Exercise #1

Due: Tuesday, Feb. 9 in class

Consider the following situation:

Bob's Video Store rents video tapes to customers. Each tape has a title, a copy number, inventory number (unique), title, category, rating, and rental cost. Each customer has a customer number, customer name, and address. We acquire tapes from vendors (vendor number, name, and address). Each tape can (over time) be rented out by several customers, and each customer can rent out several tapes. We'd like to keep track of when each tape is checked out, and when it is returned. We acquire tapes from several vendors, but each tape comes from only one vendor.

1. Sketch an entity-relationship diagram corresponding to this situation (it should not be very complex)
2. From the entity-relationship diagram, construct a relational schema. For each relation, clearly identify primary keys and foreign keys.