I just started using MySQL Workbench drawing an entity-relationship diagram that I previously designed in paper.
I want to represent a conceptual one-to-many relationship by means of three tables. For example, I have entity
A and entity
B with 1-to-N (for every
A I have many
How can I do that with three tables, one of them being a "middle" table?
Like in the diagram that follows
or like in the diagram below