Re: Looking for some assistance

From: Alan <alan_at_erols.com>
Date: Wed, 30 Jul 2003 10:29:35 -0400
Message-ID: <bg8ko3$lt41o$1_at_ID-114862.news.uni-berlin.de>


Please supply your professor's email address so we can respond directly to him. Don't worry, we'll use your name.

"Vostok" <vos72_at_yahoo.com> wrote in message news:757eivc9k5aov3psrqc9us809bp724vg7l_at_4ax.com...
> Looking for some help on this one....
>
> Given relation schema R(A,B,C,D,E,F,G,H,I), and given the set of
> functional dependencies:
> AB-->CD
> A-->E
> B-->FH
> C-->G
> D-->B
> G-->C
> H-->I
>
> What is the key for this relation schema? AND what normal form is this
> schema in?
> Then, if it's not in 3NF, decompose the schema into a set of 3NF
> schemas.
>
> TIA
>
> Mark
>
Received on Wed Jul 30 2003 - 16:29:35 CEST

Original text of this message