"Finding a relation between two attributes of a database"
Hi everyone,
my 'learning process' continues! I have a database with 2 columns. One of them contains diagnosis of some diseases. The other one contains treatment for these diseases.
Now the thing that i wan to do is to find a relation between these 2 columns. For example; diagnosis is "fever" and treatment for this diagnosis is "take a cold shower". Another; diagnosis is "fever" again but this time treatment is "pill". And goes on like this.
Like in the association examples can I find a relation like "fever->pill" ?
Can we say that "WHEN THERE IS FEVER IN DIAGNOSIS WE MOSTLY SEE PILL AS A TREATMENT".
I hope i can explain
Duygu.
my 'learning process' continues! I have a database with 2 columns. One of them contains diagnosis of some diseases. The other one contains treatment for these diseases.
Now the thing that i wan to do is to find a relation between these 2 columns. For example; diagnosis is "fever" and treatment for this diagnosis is "take a cold shower". Another; diagnosis is "fever" again but this time treatment is "pill". And goes on like this.
Like in the association examples can I find a relation like "fever->pill" ?
Can we say that "WHEN THERE IS FEVER IN DIAGNOSIS WE MOSTLY SEE PILL AS A TREATMENT".
I hope i can explain
Duygu.