AnsweredAssumed Answered

table relationship advice

Question asked by jonnyt on Oct 6, 2009
Latest reply on Oct 8, 2009 by jonnyt


table relationship advice


I was wondering if any of you would comment on the best table and relationship structure for the following scenario:-


Im create a vehicle bookings database.


1) A customer can have multiple bookings

2) Each booking has a Vehicle Class (small, medium, large)

3) Each Vehicle Class has a supplier (Hertz, Enterprise. Alamo, Dollar)

4) Each Supplier has a Rate for that vehicle class(1 day=$10)

5) Each Supplier has one or many vehicles in that class for the customer to rent


Its baffling me for some reason, so any help would be much appreciated!