Re: truck fleet

mgkiourt wrote:

> 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
>
>
>

        You can simplify this problem by restating it as "Two classes of drivers can drive trucks. Those with commercial licenses can drive any truck, but those with chaufers licenses can only drive some trucks." Just add a column to the truck table for type of drivers license required to drive the truck.

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one