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 |
|
y0zh
Yak Posting Veteran
60 Posts |
 Posted - 2010-04-22 : 10:22:23
|
| How should I implement 1-1, 1-m, m-m relationships during designing of tables? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-22 : 10:26:46
|
| 1-1 usually by means of fk relationship b/w two tables1-m,m-m by means of a third intermediate table having both tables pk as fks.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-04-22 : 10:47:57
|
| 1-M can be represented by a FK relationship like a 1-1. For example the OrderHeader and OrderDetail scenario, you have 1 Header row and n-number of Detail rows that all reference the same Order row (presumably the OrderID). |
|
|
|
|
|
|
Question about 1-1, 1-m, m-m relationships