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:
Customer Data
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?