•
•
•
•
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 370,606 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,048 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:
Views: 11100 | Replies: 4 | Solved
 |
•
•
Join Date: Jul 2006
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hotel Reservation System 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
################
My Idea:
############
Table Customer:
CustomerID
First Name
Last Name
Gender
Address
Phone
##############
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
################
•
•
Join Date: Jul 2006
Location: Remunj
Posts: 141
Reputation:
Rep Power: 2
Solved Threads: 15
Junior Poster
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.
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.
"Premature optimization is the root of all evil."
Donald Knuth
Donald Knuth
•
•
Join Date: Aug 2006
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
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 http://www.e-male.me.uk/avce_unit6.html
i hope that helps you a little!
i hope that helps you a little!
•
•
Join Date: Mar 2006
Location: Moorea, French Polynesia
Posts: 56
Reputation:
Rep Power: 3
Solved Threads: 3
Junior Poster in Training
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.
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.
•
•
Join Date: Feb 2008
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
•
•
•
•
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
Linear Mode
•
•
•
•
apple avatar backup breach computer creative daniweb data protection database design engine france google government hacker howto ibm illustrator internet leopard linux medicine microsoft navigation news normalization open operating operating system os photoshop print research search security server source sql survey switching system technology toread torvalds tutorials upgrade vista web windows xp
- Airline Reservation System (ColdFusion)
- HELP - Airline Reservation System - ERD required (Computer Science and Software Design)
- How to write a *WORKING* reservation system for public computers (C)
Other Threads in the Database Design Forum
- Previous Thread: SQL Injection Attacks
- Next Thread: Financial Accounts System
