database design - avoiding redundant data

  • Thread starter Thread starter buggirl
  • Start date Start date
B

buggirl

I'm trying to streamline my current database. I have two sorts of data about
fish - abundance and standard length (SL). Initially I set up two tables, but
now I'm wondering if I can combine these into one table?

The table I propose looks like this:

SampleID
FishName
FishSex
FishAgeClass
FishSL

Do I also need a column for abundance? The abundance will always be one (1)
because each row describes an individual fish. Or can I build a crosstab
query without the abundance column??

Thanks again!

buggirl
 
I'm trying to streamline my current database. I have two sorts of data about
fish - abundance and standard length (SL). Initially I set up two tables,but
now I'm wondering if I can combine these into one table?

The table I propose looks like this:

SampleID
FishName
FishSex
FishAgeClass
FishSL

Do I also need a column for abundance? The abundance will always be one (1)
because each row describes an individual fish. Or can I build a crosstab
query without the abundance column??

Thanks again!

buggirl
Click to expand...

Why not just use Count() in your crosstab?
 
Back
Top