Re: Looking for some assistance

From: programmer <int.consultNOCAPITALS_at_macmail.com>
Date: Wed, 30 Jul 2003 15:14:10 +0100
Message-ID: <bg8kar$5g4$1_at_pheidippides.axion.bt.co.uk>


> 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.

How far have YOU got with this question? If you post it, someone might give you some pointers. Received on Wed Jul 30 2003 - 16:14:10 CEST

Original text of this message