943,852 Members | Top Members by Rank

Ad:
Sep 23rd, 2008
0

Hotel Reservation System - Help me on Designing an ER

Expand Post »
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...
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bk1985 is offline Offline
1 posts
since Sep 2008
Sep 24th, 2008
0

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

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
Click image for larger version

Name:	Hotel Reservation and Invoicing.JPG
Views:	219
Size:	33.7 KB
ID:	7491  
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007
Oct 7th, 2008
0

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

what about if the hotel accepts multiple reservation how would you do that in database
thanks
Reputation Points: 10
Solved Threads: 0
Newbie Poster
apollo_joe is offline Offline
1 posts
since Oct 2008
Oct 8th, 2008
0

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

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.
Reputation Points: 27
Solved Threads: 29
Posting Whiz
timothybard is offline Offline
317 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: need help e-r diagram
Next Thread in Database Design Forum Timeline: Need Help! Split a record into 2 record.





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC