Database Modeling and Design, 5th Edition

Exercises

ER and UML Conceptual Data Modeling

Problem 2.1. Draw a detailed ER diagram for a car rental agency database (e.g., Hertz). Keep track of the current rental location of each car and its current condition and history of repairs, along with information for a local office, including customer information, expected return date, return location, and car status (ready, being-repaired, currently-rented, being-cleaned). Select attributes from your intuition about the situation and list them separately from the diagram, but in association with a particular entity or relationship in the ER model.

Problem 2.2. Given the following assertions for a relational database that represents the current term enrollment at a large university, draw an ER ...