Home » Developer & Programmer » Designer » Circular relationships...
Circular relationships... [message #90425] Fri, 01 August 2003 10:30 Go to next message
Messages: 284
Registered: July 1998
Senior Member

My manager has asked me to develop tables necessary to maintain relationships between three entities.

So I've mapped out the entities and their relationships as follows:
There is a many to many relationship between A_TABLE and B_TABLE.
There is a many to many relationship between B_TABLE and C_TABLE.
And there is a many to many relationship between C_TABLE and A_TABLE.

The problem comes when asked to provide everything associated with RECORD_1 in A_TABLE. I'd have to search B_TABLE and C_TABLE for all records pointing to RECORD_1 in A_TABLE. That's fine, but then B_TABLE records might relate to other A_TABLE records. And then these A_TABLE records might have more B_TABLE records associated them. And so forth.

Now, my customer has link analysis tools that should be able to handle this, but does anyone have experience with modeling this?

Am I creating a time bomb for my users? Does anyone know of a good approach?

Re: Circular relationships... [message #90447 is a reply to message #90425] Thu, 25 September 2003 13:57 Go to previous message
Messages: 79
Registered: December 2000
That is the only way you can handle it. The users will have to know waht they are doing.
Previous Topic: Range Value for SORT AREA Parameter in 9i
Goto Forum:

Current Time: Sat Jul 31 07:01:09 CDT 2021