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!