Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Recursive relationship (http://www.go4expert.com/forums/recursive-relationship-t300/)

go4expert 14May2005 13:50

Recursive relationship
 
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

shabbir 14May2005 13:53

Re: Recursive relationship
 
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

K D 16May2005 13:42

Re: Recursive relationship
 
Quote:

A recursive relationship can be defined as A relationship that is expressed about multiple records within one table.
Very nice one liner for Recursive relationship definition


All times are GMT +5.5. The time now is 02:41.