Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>ever forget a common word or term you've used a million times? Geez - I'm getting old I guess .... anyway ....
>
>what's the proper term for the table (entity) that serves as the "in between relation table" in facilitating a many-to-many relationship between two other tables?
I was taught these were called "associative entities"...they look like normal entities in an ERD, except have a diamond inscribed in them. Damn, it was a fine summer of data modelling where I learned all about that with some fellows from Ernst & Young...learned tons. Hope this helps!
BTW, different modelling programs and methodologies probably call it something different. When I was working in VAX/DBMS before the above project, they were called "junctions".
JoeK
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement