Re: Theory Question--Two tables relating in more than one way?
From: <psandler70_at_hotmail.com>
Date: 1 Mar 2005 20:05:15 -0800
Message-ID: <1109736315.786525.269720_at_f14g2000cwb.googlegroups.com>
> But can a car have one and only one primary driver? My primary might
> be your secondary vehicle.
Date: 1 Mar 2005 20:05:15 -0800
Message-ID: <1109736315.786525.269720_at_f14g2000cwb.googlegroups.com>
>-CELKO- wrote:
> But can a car have one and only one primary driver? My primary might
> be your secondary vehicle.
Ugh, I picked a terrible example. :( Yes, a car can have more than one primary driver.
> >> Also, is it a design flaw to have two tables related in more than
> one way? Does it violate TNF? <<
>-CELKO- wrote:
> No. But you need to be careful about cycles. I am having a hard
time
> coming up with a reasonable example, tho. You might want to Google
a
> series of articles by Tom Johnston in DM Review on other data
> redundancies; normalization is not enough.
I will absolutely read these articles. Thanks again for your help.
Sincerely,
Phil Sandler Received on Wed Mar 02 2005 - 05:05:15 CET