[BiO BB] database design question

[Michael Gruenberger]

Hi John,

try searching for 'normalization'. Normalization is the process of
designing a good data model. It's quite confusing the first few times
you read through it, but after you've seen a few examples you should be
able to create reasonably well designed databases.

Once you've read a few tutorials, it might be a good idea to have a look
at the example databases that come with Access to see how to create
queries and reports that can handle more complicated data structures.

However, from my experience (I teach Access for beginners) it's quite
difficult to use Access once you have more than 3-4 related tables and
you might have to use a different database system in the end.

I guess once you have designed a good data model, post it to the list
and I'm sure there are many people here who can help you fine tune it.

Hope this helps!

Cheers,

Michael.

On Sat, 2004-02-21 at 17:28, Rowland, John G A wrote:
> I am currently in the process of building a small database in MS Access for the purposes of storing (in a computationally searchable format) protocol and results data from published and unpublished material.
> 
> I would like to be able to search this database for a particular gene/protein and see all instances of its occurrence, regardless of the use of synonyms and not restrictiong it to only pulling out a specific Accession number.
> 
> Unfortunately I am unsure of the best table/relationship setup to acheive this!
> 
> Can anyone offer any insight into this problem? (I have googled and googled for about 6 months...)
> 
> Regards,
> 
> John
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://www.bioinformatics.org/pipermail/bbb/attachments/20040227/6f4381ed/attachment.sig>