Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To Link or use Foreign Keys
Message
From
11/04/2007 14:46:50
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01214601
Message ID:
01214614
Views:
10
The linkage table is ok for n to n relations, for example an address can be shared by more than one person (of the same family for example). In this case I would recommend a link table for each n-to-n relation, not 1 for all those relations.

If you have a 1 to n relation than the link table is overhead. Example : phone numbers : a person can have several, but a phonenumber can only have 1 person (just an example, maybe in your case a phone number can be shared too)
Previous
Reply
Map
View

Click here to load this message in the networking platform