Re: normalisation

On Sat, 27 Apr 2002 14:35:10 GMT, "Chris" <c_at_coelle.net> wrote:

>Car Rental Booking Department.
>
>"Each of our clients is assigned a unique client number. Other information
>we store about clients includes their name, address, telephone number and
>discount category. There are three discount categories which we use in
>conjunction with the standard rate for the car to calculate the final price
>for a rental booking. When a client makes a booking for a car, we store the
>following information for the booking: client number, car registration
>number, date delivered, date due back, date returned, kilometres when
>delivered, kilometres when returned, rental rate (depends on the type of the
>car), drivers license number of the driver (since our clients may be
>companies), and amount due. When I look up information on available cars, I
>need to view the following information: car registration number, year of
>manufacture, manufacturer and model, kilometres travelled and comments on
>the condition of the car. We keep all the booking data for the cars in the
>system, not just bookings which are currently active ( i.e. bookings for
>cars which have not yet been returned)."
>
>I came up with following relations
>
>client (client_id(PK), name, address, telephone, discount)
>
>car (reg_number(PK), year_manufactured, manufacturer, model, car_type,
>
>km_travelled, last_serviced, due_serviced, comments)
>
>rental_booking (rental_booking_id(PK), client_id, reg_number, car_type,
>
>rent_date, due_date, return_date, deliever_km,
>
>returned_km, rental_rate, drivers_license,
>
>amount_due)
>

Is this a homework assignment? ;-)

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Sat Apr 27 2002 - 16:43:41 CEST