Database Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesDatabase Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old October 8th, 2004, 11:14 AM
pierrotmb pierrotmb is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 1 pierrotmb User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Unhappy hotel booking database design

i am trying to design a hotel booking database that will allow guests to book a room and pay for their stay just like in a normal booking or an on-line booking,can someone think of the entities i should use for that? this is just for self exercise..thanks

Reply With Quote
  #2  
Old October 16th, 2004, 11:23 AM
michlmann michlmann is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2004
Posts: 56 michlmann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 11
Customer, reservation, room, pricelist... where's your specific problem?

Reply With Quote
  #3  
Old October 22nd, 2004, 06:16 PM
zounr zounr is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Oct 2004
Posts: 2 zounr User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thumbs up Entities for Hotel Reservation Software (Sheraton Hotel)

Hi Buddy,
I send u complete Database script of Hotel Reservation System, but please user it for personal practice,
Thanks,
Zounr Badar Uddin
badar300@hotmail.com
Attached Files
File Type: doc fidlylo1.doc (52.0 KB, 18223 views)

Reply With Quote
  #4  
Old September 25th, 2006, 05:19 PM
e-male.me.uk e-male.me.uk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2006
Posts: 2 e-male.me.uk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 m
Reputation Power: 0
i created a simple hotel reservation database using access, and i think it could be modified to suit ur needs. have a look at: my site http://www.e-male.me.uk or a direct link to the page

Reply With Quote
  #5  
Old January 25th, 2007, 05:58 PM
weissf weissf is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2007
Posts: 2 weissf User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 17 m 20 sec
Reputation Power: 0
access database reservation system

Quote:
Originally Posted by e-male.me.uk
i created a simple hotel reservation database using access, and i think it could be modified to suit ur needs. have a look at: my site (URL address blocked: See forum rules) or a direct link to the page


Sure wish I could take a look at that program. I am trying to create something similar for my girlfriend. Need help bad!

Reply With Quote
  #6  
Old January 31st, 2007, 05:58 AM
stallyon stallyon is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2007
Posts: 31 stallyon User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 45 m 33 sec
Reputation Power: 8
You'd first need details about the customer (tblCustomers):

First Name
Surname
Address
Telephone Number
Mobile Number
Email Address
Assign to this a CustomerID number (auto-increment)

Then you need details about the room types (tblRoomTypes):

Room Type
Num Beds
Price Per Night
And assign to this a RoomTypeID number (auto-increment)

And then details about each room (tblRooms):

Location
RoomNumber
RoomTypeID (this is taken from the tblRoomTypes table)
And add to this a RoomID number (auto-increment)

And then details about the booking:

Start Date of Booking
Num Nights Stay
CustomerID (taken from the tblCustomers table)
RoomID (taken from the tblRooms table)
add add a BookingID number (auto-increment)

you now have everything you need to design your forms and queries to add customers, make bookings and create rooms

If you need any more help then do let me know.

Reply With Quote
  #7  
Old May 11th, 2007, 05:34 PM
sait800 sait800 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 2 sait800 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 26 m 40 sec
Reputation Power: 0
Hotel reservation

Can u email the database to(E-Mail address blocked: See forum rules) as attachment or link to ur site

Reply With Quote
  #8  
Old May 12th, 2007, 05:40 AM
sait800 sait800 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2007
Posts: 2 sait800 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 26 m 40 sec
Reputation Power: 0
hotel reservation

can u email the program to sait800 at rediffmail.com

Reply With Quote
  #9  
Old August 8th, 2007, 07:02 AM
abida007 abida007 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2007
Posts: 1 abida007 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 9 m 51 sec
Reputation Power: 0
Database Development

Quote:
Originally Posted by pierrotmb
i am trying to design a hotel booking database that will allow guests to book a room and pay for their stay just like in a normal booking or an on-line booking,can someone think of the entities i should use for that? this is just for self exercise..thanks




hello there

serious trouble you must b facing bcuz designing a database is a real tough task and requires lots of understanding.. i've been facing this problem through out my educational life but i got through just bcuz of one source oracleplace.com

visit the site and find your way around .... and i am sure your problem will be solved

Good luck

Bubye

Reply With Quote
  #10  
Old March 5th, 2008, 01:51 PM
Daniyaal Daniyaal is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2008
Posts: 1 Daniyaal User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 4 m 27 sec
Reputation Power: 0
Daniyaal

Could you sent me a hotel resarvation databse using access...................or the tabes and fields

Reply With Quote
  #11  
Old November 9th, 2008, 07:25 AM
e-male.me.uk e-male.me.uk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2006
Posts: 2 e-male.me.uk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 m
Reputation Power: 0
Quote:
Originally Posted by weissf
Sure wish I could take a look at that program. I am trying to create something similar for my girlfriend. Need help bad!

Update: The hotel database is now on my new site: digiwebbs.com (link available in my profile - i would put the link on here, but i'm not allowed with being a new user

Reply With Quote
  #12  
Old December 27th, 2008, 01:01 PM
tomc486 tomc486 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2008
Posts: 1 tomc486 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 10 m 28 sec
Reputation Power: 0
Domestic & International Hotel Databas

We are interested in gaining access to a complete hotel database that contains both domestic and international hotels.

The critical information that we are looking for is;
Hotel Name
Address
City, State, Zip Code
Telephone Number
Fax Numer
Total Number of Hotel Guest Rooms

In a perfect world, the database would also contain;
Total Number of Meeting Rooms
Total Meeting Room Space in Square Feet
Largest Meeting Room
Hotel Sales Contact Name
Hotel Sales Contact E-mail Address

Reply With Quote
  #13  
Old February 4th, 2009, 12:20 AM
schraor schraor is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2009
Posts: 1 schraor User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 15 m 12 sec
Reputation Power: 0
I am looking for same

snip from above.

BUT I AM ALSO LOOKING FOR SAME

I am interested in gaining access to a complete hotel database that contains both domestic and international hotels.

The critical information that we are looking for is;
Hotel Name
Address
City, State, Zip Code
Telephone Number
Fax Numer
Total Number of Hotel Guest Rooms

In a perfect world, the database would also contain;
Total Number of Meeting Rooms
Total Meeting Room Space in Square Feet
Largest Meeting Room
Hotel Sales Contact Name
Hotel Sales Contact E-mail Address

Reply With Quote
  #14  
Old March 23rd, 2010, 02:24 PM
faith89 faith89 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2010
Posts: 1 faith89 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 56 sec
Reputation Power: 0
Stalyon,can i know how did you make the query for the rom availability based on the tables descriptiption that you had gave before this.
Realy apreciate if you would tell to me..

Reply With Quote
  #15  
Old May 25th, 2010, 12:51 AM
hfindcom hfindcom is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: May 2010
Posts: 1 hfindcom User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 21 sec
Reputation Power: 0
You can download and use our free hotel database

Hi, I am Dennis from HFind.com. We have a database of 140,000+ hotels with name, address, phone, descriptions, location, amenities and photos. You can freely download and use it on your web site(s).

Reply With Quote
  #16  
Old March 1st, 2011, 05:02 AM
rajeevbhutani00 rajeevbhutani00 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2011
Posts: 1 rajeevbhutani00 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 31 m 13 sec
Reputation Power: 0
Information given is really very good.Thanks for this useful information.

Reply With Quote
  #17  
Old April 10th, 2011, 04:08 PM
johnpers johnpers is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2011
Posts: 1 johnpers User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 24 m 42 sec
Reputation Power: 0
Red face Use an existing reservation system?

If I got the original question right, you want to develop a hotel reservation system for your website? Why not use an existing? There are a lot of reservation systems readily available. Check out compare-hotel-reservation-systems.com. We're using sirvoy.com after going through some alternatives. It's $25/month, nothing compared to developing something on your own... or at least you'll get some good input for your own development through their free trial...

Reply With Quote
  #18  
Old April 15th, 2011, 12:18 PM
wyckliffe wyckliffe is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2011
Posts: 1 wyckliffe User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 48 m 16 sec
Reputation Power: 0
database design

Hi All,

Im new here and im a web developer. im also interested in how to design database driven websites. Any idea where i can start?

PS - Im currently in need of a simple account/member creation(registration) and login form which submits to db and can be administered.

Thanks all.

Reply With Quote
  #19  
Old April 20th, 2011, 07:40 AM
pendingoffercom pendingoffercom is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Apr 2011
Posts: 1 pendingoffercom User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 12 m 17 sec
Reputation Power: 0
Quote:
Originally Posted by hfindcom
Hi, I am Dennis from HFind.com. We have a database of 140,000+ hotels with name, address, phone, descriptions, location, amenities and photos. You can freely download and use it on your web site(s).


Dear Dennis

I have applied for access to your database at HFind.com without getting any replies.

Could you please help me getting access to your database.


Reply With Quote
  #20  
Old March 16th, 2012, 01:53 AM
randy2gray randy2gray is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2012
Posts: 4 randy2gray User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 13 m 57 sec
Reputation Power: 0
Usefull info!!

Reply With Quote
  #21  
Old March 16th, 2012, 02:50 AM
hhvdketi1 hhvdketi1 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2012
Posts: 5 hhvdketi1 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 14 m 57 sec
Reputation Power: 0
Stalyon,can i know how did you make the query for the rom availability based on the tables descriptiption that you had gave before this.
Realy apreciate if you would tell to me..


Reply With Quote
  #22  
Old December 12th, 2012, 01:50 AM
dhafer dhafer is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2012
Posts: 1 dhafer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 18 sec
Reputation Power: 0
Hello

hi buddy, could u send the database to my email its, (da_sh79@yahaoo.com

thanks

Reply With Quote
  #23  
Old August 7th, 2013, 11:25 AM
heffw heffw is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2013
Posts: 5 heffw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 42 m 18 sec
Reputation Power: 0
about database design

@abida.
you said database design is a difficult task.very difficult.i realized this yesterday when i was creating tables from excell files.does it need system analysis and design.

Reply With Quote
  #24  
Old August 7th, 2013, 11:44 AM
heffw heffw is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2013
Posts: 5 heffw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 42 m 18 sec
Reputation Power: 0
same database design problem

database design principle is that the primary key in the primary table should be the foreign key in the second table. Now if you look at the zipped excel 2010 file below, two tables are easily identifiable. Item and Seller. From column A to F belong to Item Table. From column G to J belong to seller table.it you paste 15 rows of column A to F from Excell file in MS Access 2010 table then it is easily recognized that Item No is the primary key of the item table.of course its unique.now paste 15 lines from excel file of columns G,H,I,J in another table called Seller.here lies the problem if tyou want to make Seller Code as primary key then its not possible.because seller code is not unique.because primary keys need be unique.plz lets discuss as a friends what should we do to make a primary key for the secondary table.in a textbook the above problem is given as
You are involved in a volunteer organization that provides clothing and school supplies to needy children. Recently, the Board of Directors decided to open a consignment shop as a way to raise additional funds. In a consignment shop, indi-viduals bring in unwanted items, and the shop sells the items. Proceeds are split between the seller and the shop. The database must keep track of the items for sale in the shop as well as maintain data on the sellers. Each item is assigned to a single seller, but each seller may be assigned many items. The Board has asked you to create a database to store information about the consignment items. Use the concepts and techniques presented in this chapter to design and create a database to store the consignment data. Then create the necessary tables and enter the data from the Case 1-2 Consignment workbook. Create an Available Items Report that lists the item number, description, price, and seller code. Submit your assignment in the format specified by your instructor.

Reply With Quote
  #25  
Old August 7th, 2013, 11:56 AM
heffw heffw is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2013
Posts: 5 heffw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 42 m 18 sec
Reputation Power: 0
Item Number Description Price Quantity Date Posted Condition Seller Code Last Name First Name Phone Number
1663 Metal Chairs $5 4 3/1/2012 Excellent ER Edwards Randy 215-555-3853
1683 Computer Desk $25 1 3/2/2012 Good HI Herts Irene 610-555-4747
2563 Bookcase $8 2 3/3/2012 Good ER Edwards Randy 215-555-3853
2593 Clothes Hamper $3 1 2/27/2012 Fair HI Herts Irene 610-555-4747
3923 Twin Bed Frame $15 2 3/4/2012 Excellent HI Herts Irene 215-555-4747
3953 Duvet $75 1 3/4/2012 Good MT Merton Tad 610-555-9228
4343 Recliner $50 1 3/4/2012 Fair MT Merton Tad 610-555-9228
5810 Kitchen Table $30 1 3/6/2012 Fair ER Edwards Randy 215-555-3853
5930 Coffee Table $10 1 3/7/2012 Excellent MT Merton Tad 610-555-9228
6103 Patio Set $60 1 2/26/2012 Excellent SE Smythe Ellen 215-555-3679
6270 Loveseat $45 1 2/25/2012 Good SE Smythe Ellen 215-555-3679
6350 Bar Stools $15 2 3/7/2012 Good HI Herts Irene 610-555-4747
6443 End Tables $10 2 3/7/2012 Excellent MT Merton Tad 610-555-9228
7250 Metal Cabinet $4 1 3/4/2012 Fair ER Edwards Randy 215-555-3853

Reply With Quote
  #26  
Old August 7th, 2013, 11:58 AM
heffw heffw is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2013
Posts: 5 heffw User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 42 m 18 sec
Reputation Power: 0
seems homework but its not.just wanna have a friendly discussion about the same problem that you and i face.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesDatabase Development > hotel booking database design


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

© 2003-2014 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap