Hello i have to do a database of an hotel but i need help because it looks wrong and i dont know how to connect the different tables. this is what i have done so far, the names with underlines are keys. I need help because im kind of stuck so any help would be appreciated.


COSTUMER
costumerid
firstname
lastname
adress
email
phonenr

STAFF
staffid
firstname
lastname
socialsecuritynumber
shift

ROOM
roomid
roomtype

SALES
articlenr
articlename

DINNERORDERING
orderingid
amount
date

BOOKING
bookingid
costumerid
roomid
fromdate
todate

What a invoice table

ok i will try and do that, thank you for the help.

costumer presumably should read customer

a specific booking will have a specific (agreed) rate which may or may not be the same as the scheduled rate for that room or room type for that period

Id expect a table of rates
eg a single night, multiple night, weekend.
I'd expect rooms to be banded
ie
type 1 rates
type 2 rates

Id probably want to store the cusotmers credit details for a booking, or against damages / other charges

Id probably want some form of mechanism to store extra items such as food, drinks, whatever against a customer booking