Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Child to multiple parent tables
Message
From
27/01/2005 10:03:48
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Child to multiple parent tables
Miscellaneous
Thread ID:
00981194
Message ID:
00981194
Views:
62
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
Next
Reply
Map
View

Click here to load this message in the networking platform