Travel Itinerary Database (1 Viewer)

[xraive]

Hi All,

I am trying to design a travel requests app in MS Access. The program should be able to take flight/car, hotel, or taxi, arrangements and also get confirmation. Every trip sometimes requires a hotel, taxi. I have attached an image of the relationhips that I have designed. Can you take a look and see if I am going in the right direction or if there are suggestions that I can make.

 

[gemma-the-husky]

just to complicate things

can a trip be multi-hotel? if so, how many?
multi-rooms?
hotel/cruise?
can a party need more than 1 car?

you need to identify every strange request you might get, in your data analysis, so that you can handle any possible request

 

[Atomic Shrimp]

Question is crossposted here:
http://www.access-programmers.co.uk/forums/showthread.php?t=173012