| Circular relationships... [message #90425] |
Fri, 01 August 2003 10:30  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
