Data Modeling Question

From: Ioan Berbece <iberbece_at_servicesoft.com>
Date: Thu, 2 Sep 1999 14:39:09 -0400
Message-ID: <7qmg04$bs9$1@nntp3.uunet.ca>

Hello,

Suppose I have a table TA which represents entity A and a table TB which represents entity B. Between entity A and entity B there is a hierarchical relationship meaning an object of type B can have an object of type A as its parent. At the same time entity B has a hierarchical relationship with itself. The two relationships are exclusive. Something like this:

A1
|.....B1

|......B11
|......B12

B2
|.....B21

|......B211
|......B212

How can this be modeled in the database in an efficient manner and exploiting as much as possible the database built-in features (RI,...) and having an elegant solution (if at all possible)?

Thank you. Received on Thu Sep 02 1999 - 13:39:09 CDT