table design without redundancy

[Guest]

Hi
I have a table which stores information about a particular disease for a
given state county wise and year wise. Right now my table design is as
follows:

all the county names e.g: county1, county2, county3....countyN as the column
headings and the number of cases and case rates for the disease are stored in
row wise for each year.
So when I tried to store the same data with the county names as the row
entries and year(s) as the column headings, how can I add a new year(s) data
into the table with that being a new column? Is there any way the table can
be designed efficiently without any redundancy while storing the data county
wise instead of year wise.

thanks for any help.

regards
batchu

 

[Duane Hookom]

Not a very flexible design. An alternative would be to use fields like:

CountyID
CaseYear
DiseaseID
CaseCount
CaseRate