Re: circular relationships ok?

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 02 Mar 2006 15:25:00 +0100
Message-ID: <du6v7s$41i$3_at_nntp.fujitsu-siemens.com>

Alexandr Savinov schrieb:
> Volker Hetzer schrieb:

>> Hi!
>> Just in general, are circular relationships something that
>> can always be avoided?
>> Or, given a model with a circular relationship, possibly
>> spanning several tables, is there a way to get rid of them?

>
> One approach consists in using the concept-oriented data model as follows.
>
> 1. Order your tables so that if table A references records from table B,
> then A is positioned under B. For example, if an order has a field with
> its customer then you position them as follows:
>
> Customre
> |
> Order
So, what if A references B, B references C and C references A?

Lots of Greetings!
Volker Received on Thu Mar 02 2006 - 15:25:00 CET