Solution for guest problem in Holiday Books system

[Guest]

Hi,

I am currently designing a database for a leisure holiday company. The
party leaders details are stored in the holidaybooking table (as well as
details of the holiday), putting the other guests in this table would
replicate the booking id for every holiday so I cant have them in this table.

So I have a guest table which includes the guests but NOT the party leader.
My problem is that if the party leader wants to hire a facility (i.e. towel
hire) how can I put his ID in the facilityhire table when he is not listed in
the guest table. It is fine if a guest hires a facility but there no link
between the holidaybooking table and the guestID so the party leader's ID
cannot be put in the guestID field in the facilityhire table.


Please help. I know it's difficult to understand.

 

[Guest]

You need another link - between the holidaybooking table and the facilityhire
table (partyleaderid).
There is nothing to prevent you from having multiple relationships pointing
to the same table, although its not always the best design.

 

[nanne]

normailse the database well:

i would do
- relate facility to quest
- relate quest to booking
- rlate booking to partyleader

suc
Nne