# Relational Data Modeling - Recursive Relationship

### Table of Contents

## 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.

Relational Data Modeling 28 pages

- Aggregate Table (Summary Table)
- Association Table (Bridge, Cross)
- Cardinality
- (Integrity) (Constraints|action assertions)
- Data Model
- Generic Data Model
- Denormalization
- Denormalization Methods (Changing the Database Design to Reduce the Number of Joins)
- Entity-Relationship Diagram (ERD)
- Entity Relationship Model (3NF)
- Foreign Key
- Foreign Key Constraint (one-to-many relationship)
- (Xref|Cross-reference|Lookup) table
- Many-to-many Relationship (Two-way relationship)
- Normal Forms
- Database Normalization
- One-to-many / May-to-one Relationship
- One-to-One Relationship
- Primary key
- Primary Key Constraint
- Recursive Relationship
- Refactoring
- Referential Integrity (cascade)
- Relationship
- Schema
- Unique (Constraint|Key)
- View selection problem (recommending the best aggregation tables) - Data Warehousing
- Visualization

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.

**Data (State)**

Data (State)

DataBase

Data Processing

Data Quality

Data Structure

Data Type

Data Warehouse

Data Visualization

Data Partition

Data Persistence

Data Concurrency

**Data Science**

Data Analysis

Statistics

Data Science

Linear Algebra
Mathematics

Trigonometry

**Infrastructure**

Operating System

Monitoring

Cryptography

Security

File System

Network

Process (Thread)

Computer

Infra As Code

**Marketing**

Advertising

Analytics

Email

**Contact**

[email protected]

Privacy Policy

Status