A conceptual data model is a structured business view of the data required to support business processes, record business events, and track related performance measures.
The main elements of the conceptual model
Entity: is a person, organization, object, or concept about which information is stored.
Information about entities is captured as attributes: characteristics or traits that describes an entity.
Relationship: a dependency or an association between two entities.
Relationships are further qualified by identifying their cardinality: the number of instances of one entity related to instances of another entity.
Here is an example of a conceptual model representing the domain of ski resorts:
This model captures five entities and the relationships between them: SkiResort, Summit, Lift, LiftTicket, and ResortStatistics.
How to create
Watch the video below to see how this model was created using information from a free Kaggle data set:
Why do we need conceptual models?
Conceptual data modelling is a useful analysis technique that allows to:
- Name key business entities
- Capture relationships between business entities
- Enforce consistent terminology
- Identify concepts that exist independent of technology implementations
- Support business knowledge
For business analysts and architects, it is an excellent tool to have in your toolbox to create a shared understanding of data and business requirements.
For more resources on business modelling, check out my book Business Analyst: a Profession and a Mindset or the Pictures Speak series on YouTube Why Change channel.