Hi everybody!
I have a many-to-many relationship problem:
The facts:
- A Prefecture has many Municipalities.
A Municipality belongs to a single Prefecture.
(one-to-may relationship)
- A Prefecture has many Cities.
A City belongs to a single Municipality.
(one-to-may relationship)
Now
- A Municipality can have one or more Cities.
- A City can have one or more Municipalities.
That is, Municipalities and Cities have a many-to-many relation.
I think of creating a tblMunicipalityCity junction table to serve the many-to-many relationship:
tblMunicipalityCity
-------------------
[tblPrefecture] PrefectureID -> PrefectureID
[tblMunicipality] MunicipalityID -> MunicipalityID
[tblCity] CityID -> CityID
Would you think this is a good solution?