I am looking into buolding a website that would be able to give hotel availaibity + rates over the internet. I am not looking at taking booking from my website.
What I am after is building a database that would hold availability for 5 different hotels
The DB would have to return the following value:
Nbre Single rooms available
Price single room
Nbre double rooms available
Price double room
Check in date
Check out date
I have already started to work on something but I do not think it is the best I would like to get some suggestion, help from someone on how to start the db to make it easy to manage.
Thanks for your help, Didier.