Normalization (DK/NF) Anyone ? 
Author Message
 Normalization (DK/NF) Anyone ?

I realize this may not be the appropriate forum to address my question.
If you are offended please disregard this message. Otherwise see if you
can help me out.

I have this problem I was given.
        There is a relation X (A,B,C,D,E)
         With the following dependencies
        {A,B} --> C,D,E
        D --> A
        E --> B

Now I am trying to put this in DK normal Form. I am tempted to have
these  Five Relations relations,
        R1(A,D)         Key : D
        R2 (E,B)                Key : E
        R3 (A,B,C)              Key : {A,B}
        R4 (A,B,D)              Key : {A,B}
        R5 (A,B,E)              Key : {A,B}

But I realize there is a problem with R4 and R5, That is they are not in
BCNF. This is the case, since D which is a determinant of A is can not
be  a candidate key.

Is there anyway I can transform this relation into DK/NF. Please send

Thank You



Fri, 19 Aug 1994 21:41:34 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Normalization (DK/NF) Anyone ?

2. Normalization (DK/NF) Anyone ?

3. MDX Question: What's 1#I.NF%?

4. Oracle jobs in NS, NB &NF

5. Oracle jobs in Halifax, NS, Fredericton, NB, Moncton, NB, St. John's, NF

6. Please check my 1,2&3 NF for assignment

7. Boyce/Codd NF and Compositional Data

8. SQL/NF

9. NF and OORDB

10. Oracle jobs in Halifax, NS, Fredericton, NB, Moncton, NB, St. John's, NF

11. Help w/ NF's

12. 4 NF (Normal form)


 
Powered by phpBB® Forum Software