What is the relationship

[Gavx]

I am at the beginning of my first database and have a question - a recursive index - possibly.

The business is a travel agent.
Customers book activities for which the travel agent sells.
Customer buys a package with items on behalf of the guests that will accompany his group. For example I get some of my friends together for a holiday. I book the holiday with all of its components (transfers, lift tickets, ski lessons) for me and all my friends.

Next year I book another holiday with the same travel agent however this time my guests are all different.

Types of indexes;
Customer to guests = one to many
Booking number to customer = many to one or is this one to one and have more than one instance of the one customer and allow report filtering to sort it out?

Can someone please clear the fog that swirls in my head?

thanks

 

[jdraw]

See this data model
It may give you some insight on the tables and relationships involved in a generic travel agency business

 

[gemma-the-husky]

I am not sure whether it would be recursive,

it depends how you treat the other party guests. if they are all put in the customer's table, then you get a lead customer, and the other guests associated with the lead customer are other customers

if you put the other party guests into another table, then it wouldn't be recursive.

I suppose a typical recursion can have multiple levels of recursion though, and this would only have one level of recursion.