CS 480: DATABASE SYSTEMS
Homework(1):Entity-Relationship Model
Due on: 4th Feb., in the class
No late submissions accepted
If you make any assumption, you need to explain it and ensure that it is
reasonable.
1
Consider a business that rents movies (like Blockbuster). The business owns
a number of stores at variou locations. Each store has a name(which is
unique), location and one or more telephone numbers. Each movie is iden-
tified by its name, and it also has one or more actors/actresses. Each movie
belongs to some category, and one category can be a subcategory of another.
Each movie has 1 to n copies in stores. In one specific store, the copies of one
movie are identified by their serial numbers. Copies of one movie in different
stores may have the same serial number. Customer borrow copies of movies,
they are identified by their SSN. The information about each customer such
as name, birthday, and age are stored in the system. The borrowing date
and due date of each copy when it is borrowed is also included.
(a) Identify the entity sets. For each entity set, identify the primary key.
(b) Identify the relationship sets. For each relationship set, indicate the
cardinality and other features, if there is any.
(c) Draw an ER diagram to include the above information.
If you make any assumption, you need to explain it and ensure that it is
reasonable.
2
Please specify in English the Campus Building system whose ER model is
given in Figure 1. Describe all the information that you can gather from the
diagram.
1
