I want to build a simple database of football matches.

So I have two entities, team and match, and my problem is how should I design the entity diagram so I get 2 foreign keys from the same entity, for the home and visitor teams.



If I understood correctly, there is no problem adding two attributes with foreign keys to the same entity.

Was this helpful?