Hotel Booking Help

Hey guys new to posting on this forum but have used it for help on many occasions :-) Thank you

I am currently working on an assingment and need to normalize and show function dependancies of a database before i can create it in sql.

Could someone please help me

Hotel(hotelname, hoteladdress, suburb, hotelphone, fax)
Room(roomno, hotelname, type, price)
Guest(guestno, guestname, guestaddress, guestphone)
Booking(guestno, datecheckin, datecheckout, hotel, payment)

Thanks in advance

Room should contain a reference to Hotel. Typically keys and foreign keys aren't string-values (words) but id numbers. I would add a "hotelno" field to Hotel and use that in Room.

Also, I would change "hotel" in your Booking table to "roomno"... a guest is booking a specific room, right?

Is suburb the same as city? That might be helpful in a separate table. This way there's no spelling mistakes.