Relational Data Modeling - Recursive Relationship

Data System Architecture

About

recursion relationship in a relational data model

You just pretend that the recursive relation is between two tables:

  • the real one
  • and a virtual copy.

Example

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

Recursive Relationship




Discover More
Star Schema
Dimensional Data Modeling - Relationship

In a dimensional data model, you have mostly a one-to-many relationship between the dimension and the fact table between each level in a hierarchy man-to-many relationship are modeled with a bridge...
Relationships One To One To Many To Many
Relational Data Modeling - Relationship

This page is relationship in a relational model. relation (generally a table) an entity or a relationship cardinality define the type of relationships between two relations. third junction table...



Share this page:
Follow us:
Task Runner