Draw an ER model for a Video club! HyperVideo is a video club that rents videos to its members. The club wish to design a database that would allow it to keep information about its video library and the rental of cassettes made by the members. The club manager will provide you with the following information: Each rental made by a member is identified by a unique number. It indicates the date of the rental, the number of the member, as well as the identification of the rented cassettes. Members must return the tapes before 6 pm the day after the rental, otherwise the cost of another day of rental, per cassette, will be required. It is therefore important to keep the date and time of return. All movies are rented at the same rate, no matter what kind they belong to. In order to trace latecomers who have moved, we should keep in their files the name and address of a parent (who does not reside with them).
(Question of
Draw an ER model for a Video club!
HyperVideo is a video club that rents videos to its members. The club wish to design a
database that would allow it to keep information about its video library and the rental of
cassettes made by the members.
The club manager will provide you with the following information: Each rental made by
a member is identified by a unique number. It indicates the date of the rental, the
number of the member, as well as the identification of the rented cassettes. Members
must return the tapes before 6 pm the day after the rental, otherwise the cost of another
day of rental, per cassette, will be required. It is therefore important to keep the date
and time of return.
All movies are rented at the same rate, no matter what kind they belong to. In order to
trace latecomers who have moved, we should keep in their files the name and address
of a parent (who does not reside with them).
Step by step
Solved in 2 steps with 2 images