Structure suggestions

From: Brian Harcourt <briankh_at_VRchitects1.com>
Date: Wed, 22 Jul 1998 14:42:33 GMT
Message-ID: <35B5FAB7.854DB40F_at_umich.edu>

Looking for suggestions on how to structure the following; key1 will relate to key2 OR key3

    (i.e. if key2 not key3, if key3 not key2) I can only think of

    create reltable as key1, otherkey, otherkeytable; That doesn't seem good but its better than

    create reltable as key1 (pk), key2(fk), key3(fk) where one of the two latter columns will always be null.

Any ideas? Received on Wed Jul 22 1998 - 16:42:33 CEST