Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
teksm
Starting Member
1 Post |
 Posted - 2007-02-09 : 15:04:42
|
| Hi,I have database model with entities A, B, C, D, E.There are direct and indirect dependencies between them that need to be stored.For example, A has direct relation with B i.e A-->B stored in table ABB has direct relation with C i.e B->C stored in table BCA also has direct relation with C i.e A->CFrom above, A and C also have indirect relation A->B->CD and E can also potentially have similar relationships.Question - Does it make sense to store relations between 2 entities in tables like AB above? Is there better way to do it?Would the direct and indirect relations add to data integrity and validation issues?Thanks, |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-09 : 15:06:57
|
1. yes. 2. not really, but it depends on your specific requirements.3. you can't go wrong with properly normalized database.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
Best way to model A-> B, B->C and A->C relation