Problem - Price of room

[arubikdoan]

Hi all,

I am designing the hotel reservation database. But I got stuck with
the price of room. The room price depends on its categories (such as
twin, singel, double...), duration( weekly, daily...), and season
(high or off).

I have layout all my tables and relationships

http://arubikdoan.free-host.com/relationship.html

but it does not work properly. I don't know if there is anything wrong
with it. Can you help me plz ???

Thanks in advance,


Regard,


Arubik Doan