Background:
I am building a sports card database (or trying to). (In MS Access)
Situation:
The sports card database necessarily will require a lot of many to many table relationships.
Problem:
Me. I am have trouble grasping some instances of the many to many concept.
Example1: Student to Classes (I understand this)
One student can have many classes
One class can have many students
Example2: Cities to States
Key = City, State
Washington, GA
Washington, IL
Washington, IN
Washington, IA
Washington, OH
One State can have many cities (OK no problem here)
One city can be in multiple states (well....?)
It's clear that one city name can exist in multiple states
But is the many to many question we are fulfilling in database design asking if one city is LITERALLY in many states, or is one city's NAME in many states?
I am trying to understand this before moving forward further and would appreciate any advice. Because I am not naturally good at grasping database concepts I tend to miss things many times before understanding and also often overthink things.