Putting it all together

Let’s put what we’ve learned throughout this chapter together using a practical example from the Account and Contact concepts we have covered in this chapter.

Let’s imagine that there’s a fictitious bank that deals with both individuals and businesses (and therefore the people that work for that business). The fictitious bank has sales teams that deal with corporate clients, personal bankers that deal with non-corporate banking clients, and certain customer individuals who can be privy to the dealings of more than one company, such as a legal professional. Let’s imagine how the Account and Contact parts of the data model can be visualized:

Figure 8.7 – An example data model

Here, we can see how several different relationship types between Accounts and Contacts can be achieved using the Person Accounts feature and three join objects. Our fictitious bank can deal with businesses using...