hotel booking database design

i am trying to design a hotel booking database that will allow guests to book a room and pay for their stay just like in a normal booking or an on-line booking,can someone think of the entities i should use for that? this is just for self exercise..thanks

Customer, reservation, room, pricelist... where's your specific problem?

Hi Buddy,
I send u complete Database script of Hotel Reservation System, but please user it for personal practice,
Thanks,
Zounr Badar Uddin
badar300@hotmail.com

i created a simple hotel reservation database using access, and i think it could be modified to suit ur needs. have a look at: my site http://www.e-male.me.uk or a direct link to the page

Sure wish I could take a look at that program. I am trying to create something similar for my girlfriend. Need help bad!

You'd first need details about the customer (tblCustomers):

First Name
Surname
Address
Telephone Number
Mobile Number
Email Address
Assign to this a CustomerID number (auto-increment)

Then you need details about the room types (tblRoomTypes):

Room Type
Num Beds
Price Per Night
And assign to this a RoomTypeID number (auto-increment)

And then details about each room (tblRooms):

Location
RoomNumber
RoomTypeID (this is taken from the tblRoomTypes table)
And add to this a RoomID number (auto-increment)

And then details about the booking:

Start Date of Booking
Num Nights Stay
CustomerID (taken from the tblCustomers table)
RoomID (taken from the tblRooms table)
add add a BookingID number (auto-increment)

you now have everything you need to design your forms and queries to add customers, make bookings and create rooms

If you need any more help then do let me know.

Can u email the database to(E-Mail address blocked: See forum rules) as attachment or link to ur site

can u email the program to sait800 at rediffmail.com

hello there

serious trouble you must b facing bcuz designing a database is a real tough task and requires lots of understanding.. i've been facing this problem through out my educational life but i got through just bcuz of one source oracleplace.com

visit the site and find your way around .... and i am sure your problem will be solved

Good luck

Bubye

Could you sent me a hotel resarvation databse using access...................or the tabes and fields

Update: The hotel database is now on my new site: digiwebbs.com (link available in my profile - i would put the link on here, but i'm not allowed with being a new user

We are interested in gaining access to a complete hotel database that contains both domestic and international hotels.

The critical information that we are looking for is;
Hotel Name
Address
City, State, Zip Code
Telephone Number
Fax Numer
Total Number of Hotel Guest Rooms

In a perfect world, the database would also contain;
Total Number of Meeting Rooms
Total Meeting Room Space in Square Feet
Largest Meeting Room
Hotel Sales Contact Name
Hotel Sales Contact E-mail Address

snip from above.

BUT I AM ALSO LOOKING FOR SAME

I am interested in gaining access to a complete hotel database that contains both domestic and international hotels.

The critical information that we are looking for is;
Hotel Name
Address
City, State, Zip Code
Telephone Number
Fax Numer
Total Number of Hotel Guest Rooms

In a perfect world, the database would also contain;
Total Number of Meeting Rooms
Total Meeting Room Space in Square Feet
Largest Meeting Room
Hotel Sales Contact Name
Hotel Sales Contact E-mail Address

Stalyon,can i know how did you make the query for the rom availability based on the tables descriptiption that you had gave before this.
Realy apreciate if you would tell to me..

Hi, I am Dennis from HFind.com. We have a database of 140,000+ hotels with name, address, phone, descriptions, location, amenities and photos. You can freely download and use it on your web site(s).

Information given is really very good.Thanks for this useful information.

If I got the original question right, you want to develop a hotel reservation system for your website? Why not use an existing? There are a lot of reservation systems readily available. Check out compare-hotel-reservation-systems.com. We're using sirvoy.com after going through some alternatives. It's $25/month, nothing compared to developing something on your own... or at least you'll get some good input for your own development through their free trial...

Hi All,

Im new here and im a web developer. im also interested in how to design database driven websites. Any idea where i can start?

PS - Im currently in need of a simple account/member creation(registration) and login form which submits to db and can be administered.

Thanks all.

Dear Dennis

I have applied for access to your database at HFind.com without getting any replies.

Could you please help me getting access to your database.

Usefull info!!

Stalyon,can i know how did you make the query for the rom availability based on the tables descriptiption that you had gave before this.
Realy apreciate if you would tell to me..

hi buddy, could u send the database to my email its, (da_sh79@yahaoo.com

thanks