DaniWeb IT Discussion Community - Hotel Reservation System

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Database Design (http://www.daniweb.com/forums/forum142.html)

- - Hotel Reservation System - Help me on Designing an ER (http://www.daniweb.com/forums/thread147390.html)

bk1985

Sep 23rd, 2008 11:59 pm

Hotel Reservation System - Help me on Designing an ER

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

timothybard

Sep 24th, 2008 9:50 am

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

1 Attachment(s)

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.

apollo_joe

Oct 7th, 2008 11:00 am

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

timothybard

Oct 8th, 2008 3:28 pm

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.

All times are GMT -4. The time now is 3:56 pm.