# normalisation problems

From: <samsanders2000_at_my-deja.com>
Date: Mon, 20 Nov 2000 19:10:43 GMT
Message-ID: <8vbsvc\$q4p\$1_at_nnrp1.deja.com>

Hi,

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 -

```FD1: A -> B C
FD2: A D -> E F G
FD3: A E -> D F G
FD4: E -> G
FD5: B -> C

```

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 dependant on B or C. Presumably A would be a partial key to the remaining table (D, E, F, G). What would be its complete primary key?

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

Original text of this message