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 |
|
Freddie
Starting Member
29 Posts |
 Posted - 2009-06-09 : 10:39:58
|
| HellO All:how can i design a data model that has all many to many relationships tables?Exemple: a person may have many encounters, many visits and many contacts???Thanks |
|
|
asgast
Posting Yak Master
149 Posts |
Posted - 2009-06-09 : 12:00:52
|
| table1 has a list of contactstable2 has list of encounterstable3 has relations of contacts with encounters |
 |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-16 : 08:52:21
|
| To resolve an many to many relationship, you need to have an intermediate table to solve the issue.The intermediate table will have the primary keys of the tables that are participating in the Many to Many relationship.I hope this helps your answer.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
|
|
|
|
|
|
DATABASE DESING