Data Modeling - Relationships

> (Data|State) Management and Processing > Data Modeling (Relational Database, Code, Graph, Text)

1 - About

A relationship is a description that has a verb that relates two entity types:

  • has
  • consists of
  • uses

3 - Domain

3.1 - DBMS

The relationship is the core aspect of a relational database.

For instance, a many-to-one relationship is a link between two entities when one entity has a foreign key that references the primary key of another entity.

All relationships are implicitly bidirectional, meaning that they can be interpreted in both directions.

When you have foreign key that NOT references the primary key of another table, the database has not enforced referential integrity.

In a data model, two main relationship are used :

but you can found other types as :

To describe precisely the type of relationship in a data model, you use the cardinality.


3.2 - Between two variables

3.2.1 - Function

A function can also describe a relationship between two variables.

NHST try to find this relation.

3.2.2 - Category

3.3 - Natural Language

In a natural language such as English, there are four primary relationships:

  • condition,
  • direction
  • location
  • or time

modelled with the help of preposition.

Verbs provide a link to the condition/state of being of the subject.

coordinating conjunctions indicate the following logical relationship between sentences:

  • reason
  • addition
  • not another option
  • contrast
  • another option
  • contrasting addition
  • result

Adverbial conjunctions indicate the following logical relationship between two sentences, or phrases.

  • Addition
  • Emphasis
  • Comparison or Contrast
  • Cause or Effect
  • Time

4 - Recursive relation

Pretend the recursive relation is between two tables, the real one and a virtual copy.

In this case, a manager table and an employee table.

5 - Binary Relation

6 - Order Relation

Order is the most important concept in the modeling as it design the relation between entities.

Order - Relationship - greater than, …