Re: Educational disease database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It is certainly possible to do this kind of thing in Access, but it will
need a normalized data structure to give you the searchability you need.

One disease has many symptoms.
One symptom can apply to many diseases.

This many-to-many relation is resolved using 3 tables:

Disease table (one record for each disease):
DiseaseID Unique ID
...

Symptom table (one record for each symptom):
SymptomID Unique ID

Disease (a record for each combination):
DiseaseID
SymptomID
So, if a disease has 10 symptoms, there are 10 records in this table that
have the DiseaseID.

In a similar way, there is a many-to-many relation between disease and drug.

You may also want to associate many keywords with different
diseases/symptoms/drugs/whatever, so there are further relations. Sounds
like you have further descriptive text (and possibly links) associated with
these entities.

The core aspect of making this searchable is to get the right data
structure. This is called "normalization", and is the first step towards
building any database. It is the design phase, like drawing up the
blue-prints for building a house, and the usefulness of the entire database
relies on getting the right structure, with the right mix of rigidity
(locking out bad data) and flexibility (coping with unforseen issues.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"austplow" <austplow@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A49F94AB-A8B0-47E8-BA7B-C453DAB30D68@xxxxxxxxxxxxxxxx
> My aim is to create a searchable database that can display tables with
> similar values (eg. all the things that cause watery eyes; or all the
> things
> that cause watery eyes AND red eyes AND are treated by drug 'X').
> You can see an example of a record in flow chart form at:
> (http://members.westnet.com.au/austplow/diseases%20database.gif). My data
> types will appear mainly as three word fields with a few paragraph types.
>
> Subsequently to a search, I hope to display the similar data in tables.
>
> Is my intended database suited to MS Access or not?
>
> Would hand coding in XML be appropriate?
>
> How can I make the database searchable by multiple keywords?
>
> Any assistance would be greatly appreciated,
> Kind Regards,
> Leigh


.

Relevant Pages

  • Re: Educational disease database
    ... I plan to diagram my database structure and then implement it. ... > need a normalized data structure to give you the searchability you need. ... > One disease has many symptoms. ... > One symptom can apply to many diseases. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Suppression v/s Healing
    ... Understanding Basic Healing Principles of Natural Cure ... Suppression v/s Healing - The healing crisis ... but are not the cause of disease. ... The elimination of the symptom is not the ...
    (misc.health.alternative)
  • Suppression v/s Healing
    ... Understanding Basic Healing Principles of Natural Cure ... Suppression v/s Healing - The healing crisis ... but are not the cause of disease. ... The elimination of the symptom is not the ...
    (misc.health.alternative)
  • Re: Do you ever wonder why there are so few medications that actually "cure" a disease... but only "
    ... The symptoms are evidence of the disease, ... I have never heard of anybody having a pharmaceutical drug deficiency, ... odour and wetness is a silica deficiency symptom. ... Don't know why coffee would interefere with it ...
    (misc.health.alternative)
  • Re: Vlookup nightmare
    ... >dude storing or calculating PST is trivial in a database ... database if you're the one CREATING such a table. ... >and backwards compatability with a DISEASE is still a DISEASE ... representation of the relational calculus. ...
    (microsoft.public.excel)