Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.news2me.com!feed5.newsreader.com!newsreader.com!border2.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!pd7tw1no.POSTED!53ab2750!not-for-mail
X-Trace-PostClient-IP: 24.81.152.157
From: paul c <toledobythesea@oohay.ac>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.theory
Subject: Re: table design structure
References: <1134745289.403813.324450@g47g2000cwa.googlegroups.com>   <1134768194.459171.218070@f14g2000cwb.googlegroups.com> <1135000012.776197.227980@o13g2000cwo.googlegroups.com>
In-Reply-To: <1135000012.776197.227980@o13g2000cwo.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 37
Message-ID: <H7Bpf.28749$2k.22070@pd7tw1no>
Date: Mon, 19 Dec 2005 16:23:03 GMT
NNTP-Posting-Host: 64.59.144.75
X-Complaints-To: abuse@shaw.ca
X-Trace: pd7tw1no 1135009383 64.59.144.75 (Mon, 19 Dec 2005 09:23:03 MST)
NNTP-Posting-Date: Mon, 19 Dec 2005 09:23:03 MST
Organization: Shaw Residential Internet
Xref: dp-news.maxwell.syr.edu comp.databases.theory:35255

doug.fulton@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