Product Home
DTM Data Modeler Online Documentation
General Information
Product Profile
Welcome
Connect
Model Properties
View Modes
How to...
Database Objects
Entity Editor
Relationships
Indexes
Triggers
Views
Procedures
Data Types
Operations
Reverse Engineering
Object Selection
Script Preview
Settings
Data Model Report
Area Management
Additional information
Notation
Hot keys
Database utilities
Licence agreement
Product ordering
Install
Uninstall
Upgrade
Support
Glossary

Model Notation

DTM Data Modeler uses basic elements of IDEF1X notation. IDEF1X is a method for designing relational databases.
There are two basic elements of model: entity and relationship. In IDEF1X notation, entities are either independent (also known as parent or master) or dependent (also known as child or detail).
Also, relationships are either identifying or non-identifying.

Any entity must contain one or more attributes. Attributes are properties used to describe an entity. Any attribute must have name and type (data type like integer or char).

A key is a set of attributes that uniquely identify an entity instance. DTM Data Modeler supports primary keys only and every entity has only one primary key. The attributes of primary key displayed above the horizontal line in the entity box.

The following table describes method elements that can be used with DTM Data Modeler:

Model element Visual representation
 Independent Entity  Independent Entity
 Dependent Entity  Dependent Entity
 Identifying relationship
 Identifying relationship
 Non-identifying relationship
 Non-identifying relationship
 Primary Key  Primary Key