So I am busy learning databases for an rpg I have been thinking of to learn more specialized techniques with game development itself. Now I am trying to draw a conceptual data model to get things solid and clear for me to work with, but I can't quite understand the relationships between two entities. Take for example this image:
How does this work, I understand the rectangles are entities and therefore become tables in a SQL database but how can those relationships have attributes? Do they become their own tables or is the fk in
Account a multivalue with all
I can't quite grasp it yet I understand how databases work on a basic level. It just needs to click so any help or explanation will be appreciated.