Database Answers Header 1936 Cord (Click for Large Picture - 133K !!!)
Car Hire
Home Ask a Question Data Models FAQs SQL Scripts Search Site Map  

Back to the Conceptual Data Model.
The design of this Database has been created by following our General Approach.


Details: The main focus of the business is renting cars and vans, and the database is to manage the booking system.  
1) Vehicles are categorized into small cars (suitable for carrying up to 4 people), family cars (suitable for carrying up to 7 adults), and vans. 
2) Information stored for each booking includes customer, car, date of hire and date on which the vehicle is to be returned. 
3) A customer cannot hire a car for longer than a week. 
4) If a vehicle is available, the customer's details are recorded (if not stored already) and a new booking is made.  
5) Potential or existing customers can book a vehicle up to 7 days in advance depending on availability. 
6) Customers must pay for the vehicle at the time of hire. 
7) On receiving an enquiry, employees are required to check availability of cars and vans. 
8) An invoice is written at the time of booking for the customer.  
9) If the booking has been made in advance, a confirmation letter will be sent to the customer. 
10) A report is printed at the start of each day showing the bookings for that particular day.  

A. What are the Things of Interest ? A.1 Bookings A.2 Cars A.3 Confirmation Letters A.4 Customers A.5 Invoices A.6 Payments A.7 Vans A.8 Vehicles B. How are the Things of Interest related ? B.1 A Booking is for one Vehicle and one Customer. B.2 A Customer can be associated with one or many Vehicles. B.3 A customer cannot hire a car for longer than a week. B.4 A Customer can receive one or many Invoices. B.5 A Vehicle can be a Car or a Van. B.6 An Invoice is for one and only one Customer. C. What are the characteristics of the Things of Interest ? C.1 Customer details include name,address, gender telephone number. C.2 Each booking includes customer, car, date of hire and date on which the vehicle is to be returned.
Barry Williams Principal Consultant Database Answers 15th. April 2001
[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001