Re: normalisation
Date: Sat, 27 Apr 2002 15:02:20 GMT
Message-ID: <04zy8.57498$o66.176162_at_news-server.bigpond.net.au>
That is a good hint. Thanks a lot for that.
Chris
"Bob Hairgrove" <rhairgroveNoSpam_at_Pleasebigfoot.com> wrote in message
news:3ccaba76.6708846_at_news.ch.kpnqwest.net...
> >[SNIP]
> >When a client makes a booking for a car, we store the
> >following information for the booking:
> >[SNIP] ... date delivered, date due back ... [SNIP]<
>
> Instead of "date due back", it might be better to store "rental period
> days". Then one could calculate the due date (you'd need to account
> for weekends and holidays, though).
>
> Usually you rent a car for one of a number of fixed time periods, the
> rate depending on how long (i.e. it's cheaper per day to rent a car
> for a week than 7 times the rate for a single day).
>
>
> Bob Hairgrove
> rhairgroveNoSpam_at_Pleasebigfoot.com
Received on Sat Apr 27 2002 - 17:02:20 CEST