Data Model for the Motor Trade
Back to Data Model


1) Here is a Framework for Digital Initiatives
It provides a vehicle for communication between Business Users and the Data Community.


2) This is the Conceptual Model

Conceptual Model We have Subject Area Models for :-
  • Customers
  • Deliveries
  • Sales
  • Vehicles

  • 3) This is the Master Data Conceptual Model.
    The Cross Reference Tables match Brand IDs to Master IDs.

    ERD Data Model

    4) This is the Entity-Relationship Diagram (showing Key fields)
    It corresponds to the Conceptual Model shown at Item 2 above.

    ERD Data Model

    5) Getting Started
    5.1 Establish a Steering Group
    5.2 Review the Framework for Digital Initiatives
    5.3 Determine the Priorities -
  • The scope of the Conceptual Model
  • Master Data
  • Data Sources



  • © Database Answers Ltd. 2014