CRM database model example

What is CRM?

CRM "Customer Relationship Management". So, managing all the interactions between a company and its existing or potential customers. CRM is a software that stores all customer data and interactions, facilitates tracking activities, aggregates contacts, creates reports, sends emails, and automates business processes.
The goal of CRM is to keep relationships with customers by offering tailored reactions. [1] [3]

The important points of a CRM project are [2]:

• Target contacts in his market
  
• Know the needs of its customers
  
• Segment your messages and proposals
  
• Customize the commercial offer
  
• Satisfy the customer (price, quality, deadlines, purchase route, experience)
  
• Improve the way it responds to customer expectations
  
• Maintain a competitive advantage in its market
  

CRM ER Diagram example

Here is an example of a CRM Database model, this ER diagram below is done with the ERBuilder data modeler.
The documentation of this CRM database is presented here. This documentation is generated by ERBuilder modeling tool. The project file can be downloaded here.