I Have to help my bro in his assignment.. am trying to solve it.. have did sth but not able to understand properly..
can u guys help ?
Q: The owners of a video store have asked us to design a database to maintain records of their customers and videos. The Database should be able to indicate when a movie has been checked out and to whom it was checked out. The Database should also be able to recognize that one customer account can have more than one person who can check out movies. (NB: we do not need a list of “old transactions” once the video has been returned, we can forget that the video has ever been rented)
Draw the EER diagram for this database.
Mention all assumptions that you make ?
Thanks