1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Recursive relationship

Discussion in 'Database' started by go4expert, May 14, 2005.

  1. go4expert

    go4expert Moderator

    Joined:
    Aug 3, 2004
    Messages:
    306
    Likes Received:
    7
    Trophy Points:
    0
    Got a mail in my mail box today and thought of putting it here for experts to comments on this.

    What is a recursive relationship? How is it handled? Give an example
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    A recursive relationship can be defined as A relationship that is expressed about multiple records within one table. As an example if we take an employee table then there are some employees who are supervisor and some who are being supervised. This is the relationship of Supervisor and supervisee is called a recursive relationship.

    More concrete definition of Recursive relationship can be A relationship between information held in a field, group of fields, or complete record and information of the same type held in one or more other occurrences of that record, or part thereof.

    Thanks and hope this clears things out.
    Shabbir Bhiman
     
  3. K D

    K D Guest

    Very nice one liner for Recursive relationship definition
     

Share This Page