Booking System

Hi All

I have to create a databse for a project I'm doing, it is a booking system for a hotel. Quite basic, as I'm quite a novice. I have to be able to create, amend and cancel a booking and produce a list of guests for a particular date.

I think I need 3 tables. Would someone look them over and perhaps give me some advice if I am wrong.

GUEST
Guest_ID(PK)
Surname
Initials
Address1
Address2
Address3
Tel_No
e-mail

ROOMS
Room_no(PK)
Type

BOOKING
Booking_ID(PK)
Guest_ID(FK)
Room_No(FK)
Date_from
Date_to
No_of_people

This is all very new to me and normalisation is a mystery. I am grateful for any comments.

Cheers
Harelqueen

If two people are staying in a room, you only need to know the name of one person?
I noticed "No_of_people"... so I guess "MadCowDzz" can book a room for four people?
Nothing wrong with that, it's just important to note... had you needed many guest-records for one booking your table structure would be slightly different.

Other than specifying these minor specifics, your table structure looks fine to me.
I assume this is a school project as I hope a real world system would need MUCH more information =)

Thanks for your comments.

Yes, it is a school/college project and is the first attempt at building a database to practice some sql/php. This is why, as you say, little is actually needed in the way of further information and only the name of the person booking the room.

I am very new to this, so didn't want to proceed without havings someone check it out.

Thanks again,

harlequeen

Your design looks fine to be, but remember that I don't know the full requirements of your project.
Your best bet might be to consult with your instructor or even some fellow students.


Reading my post again, I cant believe I said "specifying these minor specifics" =)