| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Normal Forms and BCNF
Hi,
I am a little confused with Normal Forms and BCNF.
I have some relations and I am trying to determine it's normal form. I
also need to decompose it to BCNF forms...Any help would be
appreciated.
Here are some of the relations:
1. R(A, B, C, D) where A -> B B -> C, D 2. R(A, B, C, D) where A,B -> C B -> D 3. R(A, B, C, D, E) where B,C-> E A, B, C -> D 4. R(A, B, C, D) where A -> B C,D -> A 5. R(A, B, C, D, E, F) where A -> C, D B -> E 6. R(A, B, C, D, E) where A -> B, C, D C -> D B -> E
![]() |
![]() |