Hotel DataBase

[blereem]

Hey Everyone
I am new to access and am trying to design a simple Hotel Database as a project that i have to do in school.
So far i have Finished 2 tables and am seeking for your opinion if you guys could help me into finding the right tables and the right fields and data for the tables.
The Tables i have finished are these 2 with help from this forum.

Room Booking
includes these fields

Room Booking nr
Costumer Nr
Room nr
Date of check in
date of check out
nr of guests
Childrens
Extra Beds
Additional Info
Breakfast Required
payment method

and the other tabble is

Rooms

Room number
room type
No_People Accomodated
Bath
Shower
Smoking
View
Price of room


Also there is a tabbe that i have started designing myself

Staff

ID number
Employee Name
Date of Birth
Phone Number
Email Address

 

[jdraw]

Based on your description of your tables, it seems that a "Booking" is a fact that occurs when a Client/Guest --is assigned a "Room" --for a particular time period. Perhaps Client/Guest is on your to do list.

There are free data models at
http://www.databaseanswers.org that may help you with some table structures and relationship options. You do not need to copy/use one of these models in its entirety. You may be able to take a few "pieces" from various models to assist with what you are building.

see http://www.databaseanswers.org/data_models/hotels/index.htm and
http://www.databaseanswers.org/data_models/hotels/facts.htm

for more info.

Good luck with your project.

 

[Dmak]

A hotel database should be complex enough to be good and not "simple" unfortunately.

You'll need quite a few tables here to get things working well.

You'll need a customer table.

Include;

CustomerID (Primary Key, Autonumber)
FirstName
LastName
Title

Add1
Add2
Add3
Postcode/Zipcode
County
State
Country (from Lookup table)
PassportNumber
Tel
CellPhone
Email

This is just one of many, you should have lookup tables for things like country and state.

With regard to room price, hotel room prices are often quite dynamic depending on the day of the week, special dates (NYE for example), weeks and general time of year. The room rate should be a base rate from which you create a quote with a multiplier defined elsewhere in the database. So NYE might have a multiplier of 3 (300% and a normal weekend might have a multiplier of 0.7)

There are lot's more tables and relations needed. Keep going and stick with it, good luck.

 

[Dmak]

Having given it a little more thought, could you reconsider the database subject?

The problem is, unless you put in a lot of work, your hotel database isn't going to be that great and will appear flawed. It's potentially quite a big project.

I'd suggest going for a simpler subject on this occasion and maybe something that your school could actually use.

 

[blereem]

Thank u all for your help
the thing is that this is a small project with 4-6 tables so maybe i should name it Hostel since Hotels are Big Companies and a few queries and isn't a project that someone will actually use(at least not now)
I have created a small database with 5 tables which are

Rooms
Staff
Room Characteristics
Reservations
Guests

again thank u all for your help and if u have to add anything to these tables or a table please let me know