AnsweredAssumed Answered

table relationship advice

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

Title

table relationship advice

Post

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!

 

Outcomes