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