I could be barking up the wrong tree, but I'm trying to illustrate not only what the relationship is between entities, example, Customers shop in many stores, but also how to join the two entities. For example, two tables:
CustomerID | Name 11112 | Monkeyhead 11113 | Monkeybutt
Customer to Store data
CustomerID | StoreID | Lifetime Purchase 11112 | ABC | $23 11112 | DEF | $45
I know that it's a many to one relationship between the two entities, Customer Entity and Customer to Store Entity; but how do I illustrate that it's joined via the CustomerID columns?
Is crows foot notation the right one to use? If not, which is?