Max De Marzi has a great post on relationships.
When working with relational databases, the join tables are sometimes treated as second class citizens. If they are lucky, they’ll get some additional fields, but are often just placeholder tables connecting your main object tables together. It leads you to think about objects first, and relationships second. With graphs, you will want to switch up your thinking. You want to start thinking about how things are connected. Think about the different ways things are connected. Two people can be friends, co-workers, and neighbors all at the same time.His conclusion: ‘You will be surprised by how connected your data is once you start exploring it.”
Keywords: Joins • Max De Marzi • Relational Databases • relationships