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

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?

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


Current Time: Tue Mar 19 01:57:14 CDT 2024