I'm looking for a source for data models or examples of a well designed hotel-type reservation system. I've looked on the Web, done MSDN searches, bought both volumes of "Data Model Reference Book" by Silverston. In none of these resources can I find one good example of hotel-type reservations. What I need to know is: what is the best way to normalize the relations between a guest, a room, and the reserved dates? Should there be one record per guest per room per day? Or should it be one record per guest per room and range of dates?
I hate to reinvent the wheel (starting with a block of stone) when I know that the world is full of these systems.
Does anyone have any good ideas on where I can look for this information?
Thanks, Jim
Jim Felich
CEO, Integrated Technology
CEO, Pandora Data Systems
Santa Cruz, CA