Re: Transitive dependencies

"Mark Wright" <markwright_at_hotpop.com> wrote in message news:<dc4140a865026224ad8d4c7642789d55_at_news.teranews.com>...

<snip>

> Solution 3:
> Decompose each award category attribute (research, support) into separate
> entities:
>
> research(<institute, year, research>, amount, error) FK - research_error
> support(<institute, year, category>, amount, error) FK - support_error
> research_error(<error>, description)
> support_error(<error>, description)
>

My apologies I made a mistake in Solution 3 the relations should actually look like this:

research(<institute, year>, amount, error) FK - research_error support(<institute, year>, amount, error) FK - support_error research_error(<error>, description)
support_error(<error>, description)

Thanks,
Mark Received on Tue Oct 07 2003 - 18:38:04 CEST