Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
as of right now I'm trying to design a database which contains data involving football matches. I have two tables: Match & Football Team both containing various attributes. These are connected via many to many relationship. As far as I understand, I need a join table. In that table, I would need to contain ID of the match and IDs of both teams. Am I right or is this design flawed? I'm just a beginner when it comes to databases so I would appreciate some help.
Data model is often a matter of opinion, so here's mine: there is no "many to many" relationship between teams and matches; there is "many to exactly two". In other words, the home and away teams are attributes of a match; a match would be meaningless without either. Subsequently, you don't need the junction table.
