Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
To Link or use Foreign Keys
Message
De
11/04/2007 14:46:50
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01214601
Message ID:
01214614
Vues:
11
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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform