now i am attempting to design the hotel database. but i have problem with the structure of the database.?

Question

Could you tell me how to design the hotel database.
i have the alot of hotel wich have the name, location, rate, room type, room rate, and i have the price of low season and high season of each hotel for each room(such as single, twin, double..etc), so how can i design it?

Answer 1

No matter how you design it, remember "Boyce/Codd", at least and that each table row must be unique.

This is how I'd do it:
"Hotel table"
Hotel Number, Hotel Name, Location, Rate (if hotel itself has a rate that is not room dependant, but rather location dependant)

"Room Table"
Hotel Number, Room Type, Low Season Rate, High Season Rate

Assumptions:
Rate = Rate for the Hotel itself.
Room Rate is actually Low Season Rate and High Season Rate.
Room Rates are different between hotels.

If the room rates are the same between hotels:
"Room Table"
Hotel Number, Room Type

"Rate Table"
Room Type, Low Season Rate, High Season Rate


So, as you can see, you need to understand better the nature of the business. So a more thorough business analysis should be performed.

Hope that helps get you started.

Answer 2

there are a lot of system design approach available. You can use the DFD, ERD, flow chart or OOP(Object Oriented Programming) which can you can learn at the Computer Science Course. Try to gather the user requirement properly and analyse it in detail, until you get what actually the user wants.

Answer 3

whjy dont you search the net to see if there are similar programs that you are designing and look at how they structured their db?

http://www.hotscripts.com to start.