Basic Design Question

[Anthony Nelson]

I'm very new to db programming, so please bear with me me here. I have one table called Events (Date, Venue, Start_time), and another table called Attendees (each member is the name of an attendee for an particular event). I'm not sure how to link an event (one row in the Events table) with and entire Attendees table.

My guess is that there is a better way to organize my db, and I'm more than happy to change the current structure. I don't believe MYSQL supports inserting an array as a table member. But if it did I'd be inclined to just add a field in my Events table that included an array of attendee names.

Way out of my depth here! Thanks for any suggestions.