normalisation problems
Date: Mon, 20 Nov 2000 19:10:43 GMT
Message-ID: <8vbsvc$q4p$1_at_nnrp1.deja.com>
Hi,
I am currently working on a normalisation
assignment. I feel that I understand the theory
of normalisation reasonably well, but have
difficulty applying it to the example below -
Relation R = < A, B, C (D, E, F, G)>
where A is a primary key and the attributes in
brackets are a repeating group.
Functional dependencies -
I understand that R is not in the first normal
form (1NF) because it has a repeating group. My
intuition tells me to take out B and C into a
separate relation whose key field is A since the
other fields (D, E, F, G) are not functionally
FD1: A -> B C
FD2: A D -> E F G
FD3: A E -> D F G
FD4: E -> G
FD5: B -> C
Am I on the right track?
Is there is a clearer way of analysing the
problem?
Any clues on an approach for 2NF, 3NF and BCNF?
Any help would be gratefully appreciated Thanks in advance
Sam
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 20 2000 - 20:10:43 CET