I'm studying about db by doing some modeling exercises. But I've two doubts in a exercise.
In the exercise:
A Event can have only one organizer, and the organizer is a user, and a user can organize and participate in many events.
So this is a one to many relationship between organizer and event. My doubt is about the need to create a third table for the relation, because it's just necessary to have a third table in a many to many relationship, right?
But for example, in this case the event organizer has some attributes that don't belong to the user like "details", so we need to create a third table for the event organizer, but this table is not a relationship table it's just a normal entity table right?
But to do the relation, that a user, that is an organizer can organize multiple events and an event is organized by a single organizer, that is a user, how should we do this? Is the below correct? Because the "event_organizer" table seems a relationship table but maybe it should be a entity table.
The other doubt is that an event can have a maximum of 3 categories, and one category can have many events. So it is a many to many relationship? Or because an event can have a maximum of 3 categories is not and it needed a different approach?