Normal Forms and BCNF
From: Kasp <kasp_at_epatra.com>
Date: 12 Nov 2002 12:13:31 -0800
Message-ID: <3b04990d.0211121213.65f7d1d_at_posting.google.com>
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.
TIA. Received on Tue Nov 12 2002 - 21:13:31 CET
Date: 12 Nov 2002 12:13:31 -0800
Message-ID: <3b04990d.0211121213.65f7d1d_at_posting.google.com>
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
TIA. Received on Tue Nov 12 2002 - 21:13:31 CET