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@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 Tue Mar 01 2005 - 22:05:15 CST