[BiO BB] RE: database design question

[Ryan Golhar]

Unfortunately its not that easy.  Will all the synonyms of the
gene/protein exist in the database?  What is a computationally
searchable format?  What are you going to be searching on/for in
particular?

-----
Ryan Golhar
Analyst II
The Informatics Institute at
The University of Medicine & Dentistry of NJ

Phone: 973-972-5034
Fax: 973-972-7412
Email: golharam at umdnj.edu

-----Original Message-----
From: Rowland, John G A
[mailto:bio_bulletin_board-admin at bioinformatics.org] On Behalf Of
Rowland, John G A
Sent: Saturday, February 21, 2004 12:28 PM
To: bio_bulletin_board at bioinformatics.org
Subject: database design question


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