Sample Header Ad - 728x90

Modeling a database structure for a trip management business domain

3 votes
0 answers
1474 views
I am sketching up a database design and it is giving me some troubles. Basically something just "smells" about this design but I can't seem to arrive at a better way to do it. For example, the Joins needed to get back to Person table could be ugly. **Business rules** - A Person can go on many Trips. - Each Trip has many Destinations for its many participants (Person). - Every potential participant has an option to RSVP for a given Trip. If they RSVP for a Trip they must then RSVP for each Destination on that Trip. - Each Destination has an optional agenda (DestinationComponent) that each participant can RSVP for. - Assume that each RSVP relationship (at every level) will "contain many more data columns" required for information about the particular RSVP - for example, each participant can Vote on each Destination and DestinationComponent (Vote column has been omitted in RSVP tables within diagram). **Current diagram** This is the diagram I have created so far: enter image description here **Questions** - Is there a better way to manage these relationships? - A "master 'junction' table" for RSVPs and one for votes? I'm worried those tables would result in a massive overtime. Guidance would very much be appreciated!
Asked by thehnrytrapezoid (31 rep)
Sep 13, 2017, 12:57 AM
Last activity: Mar 4, 2018, 08:11 AM