Assistance on Table normalisation

[kamulegs]

Greetings to you all
I have been trying to design a DB to track bookings and related transactions at a small hotel( around 20 rooms) .
I am not a professional programmer. I am learning Ms Access programming by participating in online groups and reading books.
Briefs about the DB
Bookings are done in person, via email or telephone
Deposits can be paid on bookings. Not a requirement accept for new customers confirmation of booking requires a deposit.
Bookings Can be cancelled anytime .
A booking can be for many guests
A booking can be made by another person on the behalf of the guest. That person might belong to a company. ( Reason for tblBookingContacts and tblCompanies)

Purpose of the DB is to manage reservations and guests related transactions

Now i have come up with tables attached and requesting for advice on whether the DB is normalized and suggestions for improvement

Thanks in advance

Ronald

 

[jdraw]

There are existing data models at www.databaseanswers.org

Here's one that may be useful
http://www.databaseanswers.org/data_models/hotels/index.htm

 

[kamulegs]

Thanks for the link
I have got ideas to improve on mine

What i also want is a comment on the table structures i have come up with whether they are normalized.

Thanks

Ronald

 

[jdraw]

Not everyone has acc2007 or 2010 and so cannot open your accdb.
see the first few topics at this site for info on Normalisation
http://www.rogersaccesslibrary.com/forum/topic238.html

and the section on Entity Relationship Diagramming.

 

[kamulegs]

Hello jdraw

I am sory for that oversight of attaching an access 2007 DB

Thanks for the links

Now i have attached a copies of the DB in access 2000,and 2003 versions

Can please kindly look at it and advise? Before i continue, i want an expert opinion on the database schema

Thank you

Ronald.