Re: Animals Database Questions

2004-07-19 Thread SGreen
Hi David, In your database on the countries of the world think you were able to mostly avoid using numeric keys however in this case, they will save you a world of headaches. My suggestion to you: Create one table per taxonomic level, starting at Kingdom and working all of the way down to spe

Re: Animals Database Questions

2004-07-17 Thread Martin Gainty
David- generate a composite index on a unique combination such as genus/species Regards Martin - Original Message - From: "David Blomstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 17, 2004 1:03 PM Subject: Animals Database Questions

Animals Database Questions

2004-07-17 Thread David Blomstrom
I'm working on a big animals database and have a question that's a little hard to explain, though I suspect it will make sense to the pros. First, a little background. I'm tentatively setting up a parent-child relationship and putting all the basic mammal data in a separate table. Below are some s