| Author |
Topic |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-12-13 : 15:22:41
|
| Question:what do we call the table that does the n to n RelationHi,When we have Table1 and Table2, then we link both tables using a third table Table3 that relates n records in Table1 to n records in table2, how do we call Table3? There is a name in dataBase modeling for that, right? |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-12-13 : 15:38:45
|
| You break a many to many relationship into 2 one to many relationships. Is that what you are asking? |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-12-13 : 15:57:21
|
| i always called it an N-N-connector table..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-12-14 : 12:19:32
|
| some other answers were:Bridge table, linking table, Cross reference table...etcI am not sure what the Microsoft Official name for it is, may be it doesn t matter anyway :)Thanks a lot. |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-12-14 : 12:28:53
|
| Cross reference table is most likely what he's looking for... |
|
|
|
anthonyvn
Starting Member
1 Post |
Posted - 2007-12-14 : 12:31:30
|
| I think it is junction table |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
pootle_flump
1064 Posts |
Posted - 2007-12-17 : 06:30:12
|
This is something Rudy told me the other day:quote:
Originally posted by Rudy over at DBF
in physical modelling, i may say relationship table, many-to-many table, intersection table, associative table, sometimes junction tablein data modelling, there are only entities and relationships, so i would say relationship, as opposed to entity
|
|
|
|
skiplogic
Starting Member
1 Post |
Posted - 2007-12-20 : 12:43:28
|
| Cross-reference is how I was trained to name that table, usually with the two names and then appended with _xref. So if it was customer & invoice being related, the relationship table would be customer_invoice_xref. |
|
|
|
|
what do we call the table that does the n to n ...