Background:
I have slowly and painfully been working on creating an Access database for sports cards.
Database Needs:
For the purpose of this post, a user (me) will need to be able to search for cards by Sport, Location, or Team Name (or a combination thereof).
Problem/confusion:
Could someone kindly look at my screenshot to see if I am overthinking my table relationships? Everything is so connected with many to many relationships and I guess I just was not expecting that occurrence.
One Location can have Many teams
e.g. LA Rams, LA Dodgers, LA Lakers (NFL, MLB, NBA)
or LA Lakers, LA Clippers (all NBA)
One team can have played in many locations
e.g. Boston Braves, Milwaukee Braves, Atlanta Braves (all MLB)
One sport can have many teams
e.g. Braves, Yankees, Dodgers (all MLB)
One team (Name) can be in many sports
e.g. New York Giants (MLB), New York Giants (NFL)
One Sport can be in many locations
e.g. NFL, NBA, MLB all have sports teams all over the place
One Location can have many sports
e.g. Atlanta Hawks (NBA), Atlanta Braves (MLB), Atlanta Falcons (NFL)
Key:
MLB = Major League Baseball
NFL = National Football League (American Football)
NBA = National Basketball Association
Any help would be appreciated.