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@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 - 10:23:03 CST