Re: table design structure
From: paul c <toledobythesea_at_oohay.ac>
Date: Mon, 19 Dec 2005 16:23:03 GMT
Message-ID: <H7Bpf.28749$2k.22070_at_pd7tw1no>
Date: Mon, 19 Dec 2005 16:23:03 GMT
Message-ID: <H7Bpf.28749$2k.22070_at_pd7tw1no>
doug.fulton_at_gmail.com wrote:
> ...
>
> i added some sample data try and to simplify my problem:
>
> Maths , 2005 , sue, 95%
> ,john, 87%
> ,peter, 62%
> ,kate, 53%
>
> english , 2005 , john, 85%
> ,paul, 43%
> ,kelly, 62%
>
Is it not as simple as getting rid of the "repeating groups"?
Eg.,
T
data1 data2 data3 data4
Maths 2005 sue 95%
Maths 2005 john 87%
...
english 2005 john 85% english 2005 paul 43% english 2005 kelly 62%
with composite key (data1,data2,data3).
p Received on Mon Dec 19 2005 - 17:23:03 CET