# Relational Data Modeling - Relationship

### Table of Contents

## 1 - About

relationship in a relational model.

- an entity
- or a relationship

Therefore, a relationship between two relations is not always a relations between two entities.

cardinality define the type of relationships between two relations.

## 2 - Articles Related

## 3 - Type

Mapping: Information about the number of entities in each entity set which is allowed in a relationship set is indicated by specifying 1, m, % in the diagram

In a data model, two main relationship are used :

- one-to-many (or many-to-one)
- and many-to-many

but you can found other types as :

- optional on one side one-to-one
- Relational Data Modeling - Recursive Relationship
- …

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

## 4 - Relationship table

The following tables are the most common tables that holds a relationship:

- Relational Data Modeling - Association Table (Bridge, Cross) (many-to-many)
- Dimensional Data Modeling - Fact Table (one-to-many)
- Dimensional Data Modeling - Hierarchy (one-to-many)