Logical Data Modeling - Relationship Representation / Implementation / Visualisation

Data System Architecture


A relationship can be described/implemented by:



A relationship can be represented as a function

Example with a three element (ternary) relationship: <MATH> y = f(x,z) </MATH>


A binary relationship can be represented as an operator <MATH> y <= x </MATH>

Set of tuples

A relationship can be represented as a set of tuples of every entity identifier.

For instance, the relation less than or equal (⇐) on the set of integers {1, 2, 3} is the set of tuple:

<1, 1>
<1, 2>
<1, 3>
<2, 2>
<2, 3>
<3, 3>

The set of tuples can physically be implemented as:


The relationship less than or equal (y⇐x) can be represented in the set <math>R</math> against <math>R^2</math> as the below gray area:

Less Than Or Equal Relation


The below diagram defines two associations:

  • a book is published by one publisher and a publisher publishes many books
  • a book is written by many author and a author writes many books

Association Entity Example

Discover More
Data System Architecture
Logical Data Modeling - Relationship

A relationship is a model element that relates two entities . In its simple form (semantic form), it's a description that has a verb such as: has consists of uses ... entityentity setrelationship...

Share this page:
Follow us:
Task Runner