Database Design

Hotel Reservation System - Help me on Designing an ER

Please support our Database Design advertiser: $6.99 Domain Names at 1&1. Includes Free Privacy. Save Now!

•

Join Date: Sep 2008

Posts: 1

Reputation: bk1985 is an unknown quantity at this point

Solved Threads: 0

bk1985

Offline

Newbie Poster

Hotel Reservation System - Help me on Designing an ER

Sep 23rd, 2008

Please help me on designing an ER for the following scenarios..

* Guest do a hotel reservation
* Handling the billing part for the activities that the guest does during his\her stay @the hotel

Your help will be greatly appreciated, if anyone can help me...

•

Join Date: Mar 2007

Posts: 308

Reputation: timothybard is an unknown quantity at this point

Solved Threads: 26

timothybard timothybard is offline

Offline

Posting Whiz

Re: Hotel Reservation System - Help me on Designing an ER

Sep 24th, 2008

Attached is an example of the tables and relationships between the tables you can use to get you started. You will, of course, have to add the fields, but I think the tables and relationships should work for the main database structure.

Attached Thumbnails

•

Join Date: Oct 2008

Posts: 1

Reputation: apollo_joe is an unknown quantity at this point

Solved Threads: 0

apollo_joe apollo_joe is offline

Offline

Newbie Poster

Re: Hotel Reservation System - Help me on Designing an ER

Oct 7th, 2008

what about if the hotel accepts multiple reservation how would you do that in database
thanks

•

Join Date: Mar 2007

Posts: 308

Reputation: timothybard is an unknown quantity at this point

Solved Threads: 26

timothybard timothybard is offline

Offline

Posting Whiz

Re: Hotel Reservation System - Help me on Designing an ER

Oct 8th, 2008

What do you mean by multiple reservation? Do you mean if one person reserves more than one room?

In that case, there will be 2 Reservations records with the same Guest ID but different Room IDs.

http://www.timothybard.com
http://www.oliveirabard.com