Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Child to multiple parent tables
Message
De
27/01/2005 10:03:48
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Child to multiple parent tables
Divers
Thread ID:
00981194
Message ID:
00981194
Vues:
58
I have a situation where I have a child table that will be a child to two different parent tables. It's kind of like this:
PARENT 1     PARENT 2
pkParent1    pkParent2
   |            |
   --------------
          |
        CHILD
        pkChild
        fkParent1
        fkParent2
My question is...Is this good design? Is it commly acceptable to have a child with two foreign keys pointing to differnt parent tables when one or the other fk value will be null?
Thanks,
Dan Jurden
djurden@outlook.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform