I have a database/relationships scenario that I'm not really sure on how to implement. I hope that somebody might be able to help me out.
I have a list of club members in a database. Each record in the database will correspond to a website user, and a link will be established based on the user's email address so that users can see information specific to them. This much I have already achieved and it's working perfectly.
My club requires that members attend a certain number of events each year, and I'd like to be able to display to members how many and which events they have attended throughout the year.
Here's my problem: The number of members in the club is large and dynamic, as is the potential number of events each year. Because of this, I don't want my members database to need a column for every event, and I don't want my events database to have a column for every member.
How can I design my databases to be able to store and display this information?