Entity Diagram of 2 team matches database

  

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.

Solution

Hi,

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

Was this helpful?

Solution