How is the group handling Many to Many relationships when modeling relational data. Are you combining the two tables into a single query subject? What are you doing with the Junction table? We have a number of many to many relationships in our transactional system, and I would like to figure out a semi standard way of handling them.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Many to Many Modeling
- Thread starter UcfMike
- Start date
I think the standard procedure is to create 1 model subject query out of 2 facttables. The obvious example is order header vs order detail. Both can be considered facttables and should be remodelled into 1 model query subject.
How do you compensate for overcounting etc with many to many relationships?
Ties Blom
How do you compensate for overcounting etc with many to many relationships?
Ties Blom
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question