This page provides answers for the SQL Problem sets.
| SQL Exercise Set #7 | ||
|
Produce an object model and its derivative ER diagram for the following
situation:
ABC Video Rentals is a small store that rents videos and DVDs. The owner would like a database that tracks rentals and customers. There already is a point-of-sales system for the cash register. Consider that videos are to be classified by title, actor/actress (probably several per video), type of film (drama, comedy, horror, action, mystery, etc.), director, year of release, rating (G, PG, R, etc.), media (tape, DVD), and quantity of each. Customers need to be identified by name, address, phone number, and then have their rental history stored, that is, which customer rented which video when. Customers should be able to ask store clerks questions like: Has my spouse already seen this movie? What are other movies with this actor/actress? What would be a good movie based on recent rentals? |
||
| Object Model: Picture | VisioModeler File
Logical Model: Picture | VisioModeler File |
||
| SQL Problem Sets |