User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 391,612 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,618 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser:

Hotel Reservation System

Join Date: Jul 2006
Posts: 1
Reputation: gandil is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
gandil gandil is offline Offline
Newbie Poster

Help Hotel Reservation System

  #1  
Jul 30th, 2006
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
################

AddThis Social Bookmark Button
Reply With Quote  
All times are GMT -4. The time now is 12:20 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC