Many to Many Relation - How to associate
I'm working on a demand plan model for a school book retailer.
Since different schools may use different books, I must associate each store with the schools nearby in order to purchase the appropriate supply.
Given that one store sells books from multiple schools and that the same school may be sold in multiple stores, how should I efficiently map this relationship?
It is important to notice that this information is constantly being updated
Thank you so much.