Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Looking for some assistance

Looking for some assistance

From: Vostok <vos72_at_yahoo.com>
Date: Wed, 30 Jul 2003 01:24:43 GMT
Message-ID: <757eivc9k5aov3psrqc9us809bp724vg7l@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 Tue Jul 29 2003 - 20:24:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US