Re: truck fleet
From: Van Messner <vmessner_at_bestweb.net>
Date: Sat, 28 Jul 2001 20:34:35 GMT
Message-ID: <vlF87.2051$5d4.389209_at_monger.newsread.com>
Date: Sat, 28 Jul 2001 20:34:35 GMT
Message-ID: <vlF87.2051$5d4.389209_at_monger.newsread.com>
A table of drivers, a table of trucks and a table of truck types. Trucks gets a foreign key from truck types. An intersection table between trucks and drivers stores the "legitimate pairs" of truck and driver combinations.
"mgkiourt" <mgkiourt_at_otenet.gr> wrote in message
news:9juos3$1lv8$1_at_ulysses.noc.ntua.gr...
> Many drivers can drive many types of trucks.
> The drivers who hold the commercial license are qualified to drive every
> type of truck while those with the chaufeur's license can drive only some
> types, for example 0.5 t, 1.5t.
> Any modeling help?
> Thanks
>
>
Received on Sat Jul 28 2001 - 22:34:35 CEST