Member Avatar for gandil

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
################

  • 7 Contributors
  • 6 Replies
  • 11K Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by jram_0024
Member Avatar for pritaeas

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.

Member Avatar for funkyduck

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

i hope that helps you a little!

Edited by Ezzaral because: n/a
Member Avatar for carolraydon

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.

Member Avatar for BeEasy

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

Member Avatar for CasTex

Reservation Date
Arrival Date
Departure Date
RoomCategoryID
Status
TotalCost

Member Avatar for jram_0024

guys cnu may documentation ng hotel reservation?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.