Data Modeling Basics
An introduction to data modeling and modeling terminology common to relational and graph databases.
The importance of data modeling
The correct organization of data and the correct definition of the underlying database model or schema are critical to a business. TerminusDB organizes data in an object structure to facilitate modeling a business and the real world generally.
Modeling an organization
Using a small organization as an example, use the steps below to model and define a schema for the organization
and its elements - team
, project
, task
, and employee
.
Data modeling steps
Step 1. Identify the elements of the organization
Step 2. Identify the properties of each element
Step 3. Identify the relationships between elements
Element relationship modeling
For relational and graph databases, an entity or element relationship model is a good way of implementing these steps. This helps to identify the components of the schema - its elements, properties, and relationships.
Diagram: An element relationship model
Step 1. Identify the elements of the organization
Elements are similar to entities in relational database terminology.
Table: Elements of an organization
Element | Description |
| The main organization. |
| The teams within the |
| The employee assigned to |
| The projects that a |
| The tasks of the |
Step 2. Identify the properties of each element
Properties are similar to attributes in relational database terminology. A property is an item of data describing the element.
Table: The properties of elements
Element | Properties |
|
|
|
|
|
|
|
|
|
|
Step 3. Identify the relationships between elements
Relationships are the same in graph and relational database terminology. Relationships define the associations or interactions between elements.
Table: The relationship between elements
Element | Element | Relationship (phrasal verb) | Relationship description |
|
|
| An |
|
|
| A |
|
|
| A |
|
|
| A |
Last updated