Data Modeling and Design

University of Winnipeg Continuing Education

You have been asked to create a database for all aspects of a car rental agency. (Think Hertz, Tilden, etc.)

List the names of all entities about which you should collect information, even if they will not be used in the following exercise.

You are going to create a Customer Rental Agreement for each car rental. It should contain the following information:

Rental agreement number
Rental agency branch number, address and phone number
Rental agent name and employee number
Renter's name, address, phone numbers, driver's license info, credit card info, date of birth
Date/time rental began and ended
Serial number, make, model, licence number, beginning and ending odometer reading and condition of rental car.
Rental rate information (assume that each car belongs to a particular rate group)
Charges, taxes and total cost of rental
Box for special comments about this rental

On paper or software:

Determine all the fields that are required for this report only and organize them appropriately into tables.
Lay out a data model for the tables involved in the rental agreement.
- Show all the required tables and field names for each table.
- Identify primary keys, foreign keys and relationships including cardinality.

You are welcome to use any reasonable business rules you like but you must state them.

When all groups have completed the task, we will discuss your solutions and develop a solution together as a class.