I'm building a database of events for a club I'm in.
I've got a list of events and participants. Effectively each event can have multiple participants and each participant can be in multiple events (ie: a many to many relationship). I have a junction table for this and it all works correctly...