need help, I have two tables (member, event) every member has many different events, and every event has many different members as attendees. Would this be many to many relationship or one to one relationship?
Asked
Active
Viewed 27 times
-2
-
1*many* different events ...*many* different attendees .... why should this be one to one? – Jonas Wilms Mar 25 '19 at 17:48
-
Possible duplicate of [Difference Between One-to-Many, Many-to-One and Many-to-Many?](https://stackoverflow.com/questions/3113885/difference-between-one-to-many-many-to-one-and-many-to-many) – philipxy Mar 25 '19 at 18:15
-
And what do you expect, from what you have read in your references about those terms or about database design, including google hits from [so]? [ask] This is an obvious & obviously easily found faq. Please don't post duplicate questions. – philipxy Mar 25 '19 at 18:16
1 Answers
0
This would be a many-to-many relationship. This is because:
1 member can attend many events; and 1 event can be attended by many members.
You will need something like a map table to maintain the relationship between the two tables
SerShubham
- 873
- 4
- 10