database design - avoiding redundant data

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
 
P

pietlinden

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

Why not just use Count() in your crosstab?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top