Task:

To design a database based on the given case study. To investigate how entity-relationship modelling can help in the design process.

Case Study:

This case study concerns a Car Rental Company. The purpose of the database is to record which customers rent which cars. The company has a fleet of cars. Car details include the car registration, make (e.g. Ford, Nissan) and model (e.g. Mondeo, Micra). The company has many customers that can rent many cars. Customer details include their Address, telephone and drivers license number. Each customer rents a car for an agreed period of time that starts at the loan date and ends at the return date. A rental number uniquely identifies each car rental. Every time a car is returned from a rental, it is checked for damage by a service manager. Each service manager checks many cars. Before a car is rented by a customer, it is cleaned by a team of cleaner. Each cleaner cleans many cars.