Too many information to be stored

lucfer

Hi,

I have received an assignment from my teacher. I have to create a simple hotel reservation website. The website must be dynamic enough such that it can stores any number of hotels available. To make it more complicated, the room rental rate is different from time to time, based on the holiday season. A hotel can also have many kind of rooms.

The problem now is, I dont know how to store the room rate. Should I keep it in database or in a file? How do I keep it?

Please help me. I really need this reply. Thank you very much.

Installer

This sample schema might help you get started.

lucfer

Thank you very much. It really helps me.

But the sample schema uses fix room rate for each room. In my case, the room rate can change from day to day.

What I can imagine now is to store all the room rate for each day. It will require lots of database space. Seems ridiculous.

laserlight

But the sample schema uses fix room rate for each room. In my case, the room rate can change from day to day.

How is the change of room rate determined? In the schema Installer linked to, one would simply apply the changes by updating the table.

lucfer

Let say a customer want to book a room for 4 days.

According to the hotel, since the first 2 days are celebration days, they charge a little bit higher. The next 2 days are normal days. People already go to work and nobody wants to stay in the hotel.

So, there are 2 different room rate.

There can be many other reasons that the hotel operator might set different room rate. But of course they will have to let me (website operator) know if they change their the room rate.

Installer

I'm sure you know that I didn't mean to use the schema as is. Here's a quick, maybe simplistic, suggestion of how to do it:

In the "Room Table" add several more columns for different rates, e.g. "Holiday", "Summer", "Discount", "Weekend", etc. Then make (a) new table(s), with all the hotel IDs in one column, and other columns to store the to and from dates of the various rates, and/or the different rate-qualifying conditions. Then somehow ( 🙂 ) match the dates and the rates in your queries.

lucfer

Good idea. You must be a genius!!!

Thank you my friend.