Recursive Relationships

Rabbit Ears

n.

Pronunciation

/recursive riˈleɪʃənˌʃɪps/

Definition

Relationships between data objects within the same entity.

The most common type of relationship in data modeling is the one between entities. Recursive relationships are those that exist within an entity and do not require another entity to establish the link between records. A frequently found example is that of employees and managers within an employee database. All managers are employees and most employees have a manager. In order to find an employee's manager, it is necessary to identify the manager's employee id and locate them in the employee database.

Category

Data Modeling

Related Terms

Product Information Encyclopedia

©2020 by Industrial Data Associates, Inc.

4041 N. Milwaukee, Suite 301, Chicago, IL 60641, US

Logo-2CRev-34px-TM.png