any reply is eagerly awaited

[saad khan]

i had made a database on diabetes mellitus genes
and protein information
earlier the data was already in a single table but due to ceratain
issues i had to normalize it
after i had nornmalized it i passed it certain queries to which it
gave me many combinations

eg since earlier all the data was in single table if on the front end
if anybody searched for geneid he/she will get alll info abt that
particular gene pertaining to structure,pathway,drugs etc

but now after normalizing it i dont know what query to pass so that on
the front end if a user enters a gene id he/she gets all the
information relating to that particular gene id

i had tried many query statements including those involving left outer
joins and inner join
but to no avail

following are the cardinalities in the data

one gene -many proteins(zero or many)
one gene - many pathways(zero or many)
one gene -many pdb structures(zero or many)
 one protein - many drugs(zero or many


a query like this returns many results and sometimes puts the server down

SELECT `genes`.`gene_id`, `protein`.`uniprot_id`, `pathways`.`pathway_id`
FROM genes, protein, pathways, pdb
WHERE (`genes`.`gene_id` = '3683')


moreover i also want to know if i should include gene_id in drugs
table as foregn key