Re: Can FK be nullable/optional by design?
Date: 3 Dec 2003 09:15:34 -0800
"Trey Walpole" <treyNOpole_at_SPcomcastAM.net> wrote in message news:<u3p24vCuDHA.3144_at_tk2msftngp13.phx.gbl>...
> depends on what a Group is and how it is used...
> is a Group a Super-Client? -- individual Clients may be subsidiaries of a
> is a Group in internal designation, like a Sales territory?
> How many Clients are there likely to be w/o a group?
> When you need to act on the clients that are grouped, do you also need to
> act on the clients that are not grouped?
> [ps. in Case B, where did PersonID come from? Is that the Client?]
Yes, it does.
It should be this way
[ps. in Case B, where did PersonID come from? Is that the Client?]
Group(GroupID PK, Name, GroupCode.)
Client (ClientID PK, Name, ..)
GroupedClient (ClientID PK/FK, GroupID FK NOT NULL) Received on Wed Dec 03 2003 - 18:15:34 CET