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: Multiple databases
Next Topic: DB design to Automate Business proposal generation
Goto Forum:

Current Time: Wed Aug 23 18:24:59 CDT 2017

Total time taken to generate the page: 0.12481 seconds