944,202 Members | Top Members by Rank

Web Development > Databases > Database Design > Hotel Reservation System
Ad:
Permalink
Jul 30th, 2006
1

Hotel Reservation System

Expand Post »
Can you help me to normalize Online Hotel Reservation System. In the database I will store information about the hotels (name, city, country, number of stars, room prices, total number of double rooms, total number of single rooms, number of available rooms, etc); customers (name, email, telephone, address, username, password, etc); reservations (username of the customer who made the reservation, Hotel ID, date of arrival, date of departure, total cost, and etc.).

My Idea:
############
Table Customer:
CustomerID
First Name
Last Name
Gender
Address
Phone
Mail


##############
Table Hotels
HotelID
Name
Address
City
Phone
Number of Stars

###############
Reservation Table
ReservationID
CustomerID
HotelID
Reservation Date
Arrival Date
Departure Date
RoomCategoryID
Status
TotalCost

###############

Table Room Categories
Category ID
Category Name
Number of beds


################
Table Rooms
HotelID
Room Number
Category ID

################
Table Room Price
HotelID
Category ID
Season
Duration
Room Price
################
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
gandil is offline Offline
5 posts
since Jul 2006
Permalink
Aug 3rd, 2006
0

Re: Hotel Reservation System

The normalization is okay at this point.

Is this going to be a live system, or just a test ? Because if you want to book rooms, you'll need to know what rooms are available. Suppose a room cannot be sold due to maintenance.
Sponsor
Featured Poster
Reputation Points: 557
Solved Threads: 734
Bite my shiny metal ass!
pritaeas is offline Offline
4,207 posts
since Jul 2006
Permalink
Aug 31st, 2006
0

Re: Hotel Reservation System

i have made a hotel database using microsoft access. its only basic, such as booking rooms and sees which rooms are avaliable using simple sql. you can download it and the documentation from my website [URL removed]

i hope that helps you a little!
Last edited by Ezzaral; Apr 23rd, 2010 at 2:15 pm.
Reputation Points: 10
Solved Threads: 1
Newbie Poster
funkyduck is offline Offline
1 posts
since Aug 2006
Permalink
Jan 23rd, 2007
-1

Re: Hotel Reservation System

Hi,
You need to break your reservations table into 'main' & 'details': what if a family books 2 rooms? What if they change rooms during their stay? You want it to show up as one reservation, with it's various details.
Also, you have number of beds, but not number of guests...
Have fun.
Reputation Points: 10
Solved Threads: 3
Junior Poster in Training
carolraydon is offline Offline
57 posts
since Mar 2006
Permalink
Feb 26th, 2008
0

Re: Hotel Reservation System

Quote ...
Reservation Date
Arrival Date
Departure Date
RoomCategoryID
Status
TotalCost

Hi

I think you would have a problem with this table because it don't refer to the customer

you must make a link between the two tables

regards
Reputation Points: 10
Solved Threads: 1
Newbie Poster
BeEasy is offline Offline
4 posts
since Feb 2008
Permalink
Jun 20th, 2009
0

Re: Hotel Reservation System

Reservation Date
Arrival Date
Departure Date
RoomCategoryID
Status
TotalCost
Reputation Points: 3
Solved Threads: 0
Light Poster
CasTex is offline Offline
45 posts
since Mar 2008
Permalink
Mar 2nd, 2010
-1
Re: Hotel Reservation System
guys cnu may documentation ng hotel reservation?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jram_0024 is offline Offline
1 posts
since Mar 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
This thread is currently closed and is not accepting any new replies.
Previous Thread in Database Design Forum Timeline: ERD
Next Thread in Database Design Forum Timeline: banking system software - BDO





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC