Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Link table
Message
De
08/10/2009 10:01:34
Sergio Ortiz
Tek Services Group, Llc
Hollywood, Floride, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Link table
Divers
Thread ID:
01428259
Message ID:
01428259
Vues:
98
I have two tables called Menus and Menus_Item.

I have allways join both tables by using PK from menus and storinging it in a FK field on the Menus_item.
But I was looking at somebody else database desing and he was using a link table to join both tables.

The link table name is Menus_Menus_item_link.
This table has a field for storing the PK of the Menus table and a field for storing PK of Menus_Item table.

Question : Is this a better database desing ?. What are the benefits of having a link table?
I have never used link tables and I am a little bit confused.

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform